[Resolved] Drop down lists

thewalluk

I'm having a problem.I have a page with a drop down list but i want the options to be generated from a database.

The code I have at the moment is:

include('../generic/connect.php');
	  $Link=mysql_connect($Host, $User, $Password);

$Query = "SELECT * FROM photo_album";
$Result=mysql_db_query ($DBName, $Query, $Link);

while ($Row = mysql_fetch_array ($Result)){
    print("<select name=\"albums\">");

print("<option value=\"$Row[album_name]\">$Row[album_name]</option>");
}
mysql_close ($Link);
print("</select>");

This shows the list but their are no options. Can anyone see where I'm going wrong and advise me please.

chads2k2

// Create the selection box.
print("<select name=\"albums\">");

// Include the database connection
include('../generic/connect.php'); 
$Link=mysql_connect($Host, $User, $Password); 

// Query the database.
$Query = "SELECT * FROM photo_album"; 
$Result=mysql_db_query ($DBName, $Query, $Link); 
while ($Row = mysql_fetch_array ($Result))
{ 
     $temp_album_name = $Row['album_name'];
     echo "<option value='$temp_album_name'>$temp_album_name</option>";
} 
mysql_close ($Link); 
print("</select>");

I haven't tested this but I am pretty sure it would work. What you were essentially doing is having the print("<select name=\"albums\">"); be called everytime there was a record. Well, that's not what your looking to do. Let me know if this works. I am pretty sure it will. Thanks!

Chad

thewalluk

The code didn't work. I copied it exactly and nothing. Thanks for your help and if you think of anything else let me know.

osnewbie2004

Hello!,

The code below works for me....

$result = mysql_query("SELECT Home_Name FROM homes");

if (!$result) {

echo 'Could not run query: '.$result."\n". mysql_error();

exit;

}
echo "<select name=\"Var_Home_Names\">";
for ($i=0; $row = mysql_fetch_assoc($result); $i++)
{
echo "<option value=\"" .$row["Home_Name"]. "\" >". $row["Home_Name"]. "</option>\n";
}
echo "</select>\n";

Thanks,
Sean

thewalluk

Thanks for the reply but i have managed to solve it know. It was connecting using the generic connect file. Thanks to everyone who helped though