Displaying groups from SELECT
| From: | Becoming Digital | Date: | Sat, 07 Jun 2003 01:49:19 +0000 |
| Subject: | Displaying groups from SELECT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28389@lists.php.net to get a copy of this message | ||
I'm wearing the stupid hat today, so please pardon this. I know I must be
overlooking something.
I have a small catalogue with two tables (categories, products) from which I'm
trying to display items. I'm trying to print the contents as below without
using two queries, but I'm having a difficult time with it.
cat1
prod1
prod2
cat2
prod1
prod2
etc.
I think this came up fairly recently, but I cannot for the life of me figure out
what search terms would answer this question. As you can see from the message
subject, I don't even know how to refer to my problem. Thanks a lot for all
your help.
Edward Dudlik
Becoming Digital
www.becomingdigital.com