RE: [PHP-DB] Retrieving and Printing Categories

append the correct 'ORDER BY' clause to the end of your SELECT statement syntax: ORDER BY fieldname_1 [[, fieldname_2], fieldname_n] shouldn't matter what tables they are in as long as you can get the records with SELECT -----Original Message----- From: Jordan Elver [mailto:jjelver@worldsites.net] Sent: 25 April 2001 14:31 To: PHP Database Mailing List; PHP General Mailing List Subject: [PHP-DB] Retrieving and Printing Categories Hi, I've got a load of records that are in different categories. What is the best way to get all the records or selected records and print them in such a way that they are grouped (on the page) in their relevent category, like: Fruit -> Apples -> Pears -> Bananas Vegetables -> Carrots -> Cabbages etc, etc. Sometime my categories are ina dfferent table, don't know if this matters? How can I do this? TIA, Jord -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net _____________________________________________________________________ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Control Centre. For further information visit http://www.star.net.uk/stats.asp _____________________________________________________________________ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Control Centre. For further information visit http://www.star.net.uk/stats.asp