[SOLVED] Populate Select List

[Clinton]

Can't figure out my error...

 

Database is called project

table is called cities

column is called city

 

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("project", $con);



				 $sql = "SELECT city FROM cities "."ORDER BY cities";

				$rs = mysql_query($sql);

				while($row = mysql_fetch_array($rs))
				{
    				extract($row);
  					echo "<option value=$city>$city</option>";
				}

				mysql_close($con);

				?>

[premiso]

Whats the error?

[.josh]

for one, you are ordering by your table name

[Clinton]

I'm a bonehead. That was it.  :-\

 

Thank you.