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

[Tom Dell'Aringa]

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:

http://www.pixelmech.com/test/results.html

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...

Tom

=====
var me = tom.pixelmech.webDeveloper();

http://www.pixelmech.com/
http://www.maccaws.com/
[Making A Commercial Case for Adopting Web Standards]

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com