dropdown is blank

[jeff5656]

I have a table called states, but when I do a while loop to populated a dropdown, the dropdown has no content.  I use this code for other dropdowns with no problems. Any ideas?

 

<select name="state"><?php
$q = "SELECT * FROM states ORDER BY states";
$result=mysql_query($q) or die (mysql_error());
$num_svcs=mysql_num_rows($result);
while ($row = mysql_fetch_assoc ($result)) {
?><option value="<?php echo $row['abbrev'];?>"><?php echo $row['name'];?></option>
    <?php
}?>
</select>

[PFMaBiSmAd]

When you do a 'view source' of the page in your browser, what do you get?

[ndee]

By the looks of it, it seems like something's wrong with the MySQL query. Double check everything.

 

Good luck;

Andy.

[jeff5656]

Wow you are smart.  The error was stuck inside the dropdown in HTML so I never saw it untik I viewed the source.  Very clever of you :-)

 

 

 

<select name="state">Unknown column 'states' in 'order clause'

 

I turns out the fieldname was "name" not state. Thanks!!