Re: Showing multiple option list from db query?

> 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? <? $result = mysql_query("SELECT * FROM table"); while($row = mysql_fetch_assoc($result)) { $option[$row['catid']] = "<option value='{$row['Name']}'>{$row['Name']}</option>\n"; } Then use $option[1] and $option[2] in your different select boxes. <select name="male"> <?=$option[1]?> </select> ---John Holmes...