MySql equivalent of "ORacle Connect by Prior" clause ?

[Ben Goswami]

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. [phone] ext. 3300
*******************************************