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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
_____________________________________________________________________
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
