in reply to MySQL looping

If your still confused , im tring to find each category that makes up the category ff. "ff" has a parent number of 10, thats xx's id, and xx has a parent of 9 which is aa's and so on.

Replies are listed 'Best First'.
Re: Re: MySQL looping
by Nightblade (Beadle) on Jul 19, 2002 at 23:05 UTC
    while($id) { $sthm = $dbh->prepare("SELECT name,parent FROM category WHERE id ='$i +d'"); $sthm->execute or die $dbh->errstr; ($name,$id) = $sthm->fetchrow_array; $title = "$title >> " . $title; }
      that didnt do anything