Form problems

[Anon]

Hello, i am trying to create a form that allows the user to update their database site. I am having problems with some dropdown menus which i want to display the existing categories under which their stock is organised. I have a dropdown menu displaying existing categories and a text input field for entering a new category. But my problem at the moment is that it is not displying my existing categories...can anyone tell me why? Thanks

$db = mysql_connect("localhost","root");
mysql_select_db("test",$db);

echo "<select name=\"category\">
<option selected>select existing category.......</option>";

$result = mysql_query("SELECT * FROM general GROUP BY category",$db);
while ($myrow = mysql_fetch_array($result)) {

printf ("<option value=\"$myrow[category]\">$myrow[category]\n");}

echo "</select>";

[tomhath]

That select looks wrong to me, are you sure it works? How about something like this:

select distinct category from general

[Anon]

Sorry, are you talking about the way i am selecting information from the db?, if so this would be the first time that i have encountered a problem using that same method...the dropdown menu for subcategories seems to work fine (as in the subcategories are displayed in the dropdwon menu) it just doesnt seem to want to do the same for the categories dropdown, it just gives me one blank space...???