Populating a select box

[Anon]

02/11/2000

Hi,, can someone help with how to populate a select box with data from mysql.

I have the following code so far, but nothing gets displayed on the page.

<form><select name="Category">
<?php // with a while loop
// this loop will iterate as many times as there are records
while($myrow = mysql_fetch_array($result))
{
$topic = $myrow["topicid"];
$topic1 = $myrow["topicname"];
echo "<option value=$topic>$topic1</option>\n";
//echo "$topic";
}

	 // memory flush
                     mysql_free_result($result);

	 ?> 
         </select> </form>

[Anon]

Where is your select statement? Your code seems okay but there is no data ebing passed.
YOu can check to make sure your query is returning results by printing the mysql_num_rows($result); after running your query.

[Anon]

Thanks for the response..

I finally found out what i was doing wrong ..

When referencing the database fields, it was not typing in them the way they are shown in the db .. Duh!!

instead of typing in :

$topic = $myrow["TopicID"];
$topic1 = $myrow["TopicName"]

i used

$topic = $myrow["topicid"];
$topic1 = $myrow["topicname"];

[Anon]

Oops acutally the above code is not working properly, it only display one record, when there are 16. The code is only showing the 16th record. Any ideas ?