There's this table with the following fields: item_id, parent_id, and comment. Item_id is the unique identifier of each record, and each record can be a child of another. Parent_id reflects this relationship.
I need to return a recordset sorted by parent_id, i.e.:
item_one
-- item_two
---- item_three
-- item_four
---- item_five
------ item_six
-------- item_seven
item_eight
-- item_nine
---- item_ten
etc...
Help! I know how to do this in SQL Server and Oracle using temp tables, but am not finding the answer in MySQL.
M
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
