From: Date: June 6 2003 6:28pm
Subject: MySql equivalent of "ORacle Connect by Prior" clause ?
List-Archive: http://lists.mysql.com/mysql/141951
Message-Id: <04ff01c32c48$b5058090$6401a8c0@c224673a>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Hi,
Any one knows if MySQL implemented the feature which is equivalent to
Oracle's "Connect by Prior"
clause.  This is needed for retrieving 'Tree' result set from a table like :

thanks
BG

----- Original Message -----
From: "Juan Carlos Escobar Gzz" <jceg@stripped>
To: <mysql@stripped>
Sent: Friday, June 06, 2003 9:00 AM
Subject: error message


    Hi!
    I have executed this instruction:
    $sess = mysql_db_query("$db","select * from session where ID =
'$session'");

    $brow = mysql_result($sess,0,browser);

    Why display this message:?

    Warning: Unable to jump to row 0 on MySQL result index 4 in

    What is my error?

    Thanks,

*******************************************
Ing. Juan Carlos Escobar González
Jefe de la Unidad de Informática
Secretaría de Desarrollo Económico
Gobierno del Estado de Chiapas
Tel. 01 962 6 28 94 50 ext. 3300
*******************************************