Hi
 
I've got the code for a drop down list and the drop down box displays--but
with no info in it.  The underlying table is populated so I could use some
advice on what might be wrong from here....
 
<SELECT>
      <?
include("includes/db.php");
 
MYSQL_CONNECT(HOST,USER,PASS) OR DIE("Unable to connect to database"); 
@mysql_select_db(DB) or die( "Unable to select database");
 
$query=("select * from community order by community");
 
$result=mysql_query($query) or die ("Unable to Make the Query:" .
mysql_error() ); 
 
while($row=mysql_fetch_array($result)){ 
 
echo "<OPTION VALUE=".$row['community']."</OPTION>";
}
?>
</SELECT>
 
Any ideas?
 
Thanks
 
Dan
 

Reply via email to