[Resolved] bloody dropdown menu

k994519

Hi guys,

can you please look at my code and tell me why it does not input the field description into the drop down menu......

here is the code



echo "<select description='description' value=$description>"; 
$connection = @mysql_connect("server", "name", "password") or die("connect"); 
$db = @mysql_select_db("DATABASE", $connection) or die ("no connect"); 
$sql = "select * from modules"; 
$result = @mysql_query($connection, $sql) or die ("no Run"); 
while($row = mysql_fetch_array($result))
	{ 
echo "<option VALUE='$row[5]'>$row[5]"; 
} 
?>

why does it not work, please help please
please

superwormy

Try:

echo "<option VALUE=\"" . $row[5] . "\">" . $row[5] . "</option>";

And get rid of the @ in front on mysql_query so you can see if there are errors in your SQL.

k994519

hi superwormy

ive tried to what u said it does not work

please help

Weedpacket

Need more information. What does it do ("not work" is not enough). What does the output say? Do you get any error messages? What do they say? See these threads for advice on how to solve programming problems and giving enough information to help us help you.

k994519

Hi guys,

sorry for the brief message bleary eyed.

The code above works but the drop down menu does not hold any elements of the field description from the table modules.

if anyone could help me insert that field into the dropdown menu.. I would very much appreciate it..

thanks

ahundiak

mysql_query($connection, $sql)
should be
mysql_query($sql,$connection)

MattDurnan

Why dont people just use:

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

$query = mysql_query("SELECT * FROM whereever WHERE what='$what'");
$row = mysql_fetch_array($query);

Most people make things complicated for themselves when it doesnt need to be.