[thelist] manipulating rows in the result set with PHP help

Tom Dell'Aringa pixelmech at yahoo.com
Wed Dec 11 10:14:00 CST 2002

Hey all,

Got my SQL down, now need some help with the displaying of the
information correctly. You can see my SQL statement and the result
set here:


My first stumbling block is that when a category (categoryName in the
results) has a subcategory (subcatname), I want to list the
subcategory info within or under the category info.

So let's say I'm on the second row of my result set (Lunch). Lunch
has a subcategory of Side Order, and there are 2 rows of side orders.
I'm on the second row of my result set in my $row =
mysql_fetch_array($result), how do I at that point jump down a few
rows, write out that info, then come back up? Doesn't seem possible,
or seems I am thinking about this in the wrong way...


var me = tom.pixelmech.webDeveloper();

[Making A Commercial Case for Adopting Web Standards]

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.

More information about the thelist mailing list