Showing multiple option list from db query?
| From: | Dave Carrera | Date: | Thu, 03 Oct 2002 12:32:17 +0000 |
| Subject: | Showing multiple option list from db query? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22197@lists.php.net to get a copy of this message | ||
Hi All
I have a database (mysql) that has some rows entered.
Format:
Name | Desription | catid
This has some info in it like this
Joe Man 1
Jack Man 1
Jacky Female 2
Emily Female 2
What I am trying to do is create dynamically created select lists so
that all with catid 1 are in the fisrt select list and all with catid 2
are in a separate second list and so on.
I have it nearly working but the first list gives the cadid 1 result the
second gives catid 1 and catid 2 result and so on.
So how would I split the results?
As always I thank anyone who helps me with this issue fully in advance.
Dave C