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

[Luther, Ron]

Hi Tom,


If the data is coming back the way you want, then using an "ORDER BY"
clause can sort the records so they are easier to process.

But ... are you sure that table is what you want?

Do you really want to return:
'Lunch --- Side Order'
'Side Order --- French Fries'

Instead of:
'Lunch --- Side Order --- French Fries'?

RonL.

-----Original Message-----
From: Tom Dell'Aringa [mailto:pixelmech at yahoo.com]

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