Drop down menu and MySQL

dkin · Dec 19, 2002

Hello,

I tried to build a drop down menu that its content is a MySQL data. Unfortunately it does not work.

Can anyone tell me what the problem is?

Script (HTML file):

<html>
<head>
<title> Untitled </title>

</head>
<body>
<tr>

<td height="86"></td>
<td colspan="4" rowspan="2" valign="top"><select name="spec[]" size="6" multiple id="spec">
<option value="All" selected>All
<?php

$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'car';
$table = 'list';

$link = mysql_connect($host,$user,$pass);
if(!$link) die(mysql_error());
$select = mysql_select_db($db);
if(!$select) die(mysql_error());

$query = "SELECT species FROM list";
$result = mysql_query($query);
if(!$result) die(mysql_error());
echo "<select name=\"species\">\n";
echo "<option value=\"\"> </option>\n";
while($row = mysql_fetch_array($result))
{
echo "<option value=\"$row[species]\">$row[species]</option>\n";
}
echo "</select>\n";
echo "<P><input type=\"submit\" value=\"submit\"></p>\n";
?>

</select>
</select>

</tr>
</body>
</html>

Sarky78 · Dec 19, 2002

change this line

echo "<option value=\"$row[species]\">$row[species]</option>\n";

to this:

echo "<option value=\"$row[species]\">$row[\"species\"]</option>\n";

notice the quotes around the field name you want to pull from your database

hope this helps!

BB101 · Dec 19, 2002

i much prefer to do the following:

echo "<option value='".$row['species']."'>".$row['species']."</option>\n";

Quotes around array elements, array items to be used outside of the string. --BB

ashz · Dec 19, 2002

Thanks, Tested the correction, but the results form the while loop do not send them to the drop down menu but outside of it.

How can I fix it.

Thanks

Script:
<html>
<head>
<title> Untitled </title>

</head>
<body>
<tr>

<td height="86"></td>
<td colspan="4" rowspan="2" valign="top"><select name="spec[]" size="6" multiple id="spec">
<option value="All" selected>All
<?php

$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'g2mod';
$table = 'main';

$link = mysql_connect($host,$user,$pass);
if(!$link) die(mysql_error());
$select = mysql_select_db($db);
if(!$select) die(mysql_error());

$query = "SELECT species FROM main";
$result = mysql_query($query);
if(!$result) die(mysql_error());
echo "<select name=\"species\">\n";
echo "<option value=\"\"> </option>\n";
while($row = mysql_fetch_array($result))
{
echo "<option value='".$row['species']."'>".$row['species']."</option>\n";
}
echo "</select>\n";
echo "<P><input type=\"submit\" value=\"submit\"></p>\n";
?>

</select>
</select>

</tr>
</body>
</html>

ashz · Dec 19, 2002

Tested the correction, but the results form the while loop do not send them to the drop down menu but outside of it.

How can I fix it.

Thanks

Script:
<html>
<head>
<title> Untitled </title>

</head>
<body>
<tr>

<td height="86"></td>
<td colspan="4" rowspan="2" valign="top"><select name="spec[]" size="6" multiple id="spec">
<option value="All" selected>All
<?php

$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'g2mod';
$table = 'main';

$link = mysql_connect($host,$user,$pass);
if(!$link) die(mysql_error());
$select = mysql_select_db($db);
if(!$select) die(mysql_error());

$query = "SELECT species FROM main";
$result = mysql_query($query);
if(!$result) die(mysql_error());
echo "<select name=\"species\">\n";
echo "<option value=\"\"> </option>\n";
while($row = mysql_fetch_array($result))
{
echo "<option value='".$row['species']."'>".$row['species']."</option>\n";
}
echo "</select>\n";
echo "<P><input type=\"submit\" value=\"submit\"></p>\n";
?>

</select>
</select>

</tr>
</body>
</html>

danielhozac · Dec 19, 2002

You have a lot of basic HTML mistakes in your code. I suggest you pick up a HTML book and read it... //Daniel

jet042 · Dec 23, 2002

Here is the PHP code that I have used previously to make a dropdown list from a MySQL database. This was used to add data to existing tables in a multi-table database. It's only partial, but I think you can get the rest of it figured out.

$conn = @mysql_connect("HOST","USER","PASSWORD&quot

or die("Could not connect.&quot

;
$db = @mysql_select_db("DATABASE",$conn) or die("Could not open database.&quot

;
$table = @mysql_list_tables("DATABASE&quot

or die("Could not list tables.&quot

;

$step_one = "
<FORM METHOD=\"post\" ACTION=\"$PHP_SELF\">
<P>Add item to:
<SELECT NAME=\"tname\">";

for($tc = 0; $tc < mysql_num_rows($table); $tc++) {
$table_name[$tc] = mysql_tablename($table, $tc);
$step_one .= "<OPTION VALUE=\"$table_name[$tc]\">$table_name[$tc]</OPTION>";
}

$step_one .= "
</SELECT>
<INPUT TYPE=\"submit\" NAME=\"submit\" VALUE=\"Add Item\"></P>
</FORM>";

echo $step_one;

jimoblak · Dec 23, 2002

Get rid of the two extraneous closing <select> tags...

</select>
</select>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Drop down menu and MySQL

dkin

Programmer

Sarky78

Programmer

BB101

Programmer

ashz

Programmer

ashz

Programmer

danielhozac

Programmer

jet042

MIS

jimoblak

Instructor

Similar threads

Part and Inventory Search

Sponsor