using a list box with a query

Treo

I am trying to query a MySQL table. I want to be able to have a list box with the column of "name" in the table "data". then select a single name from the list box and have it output the values in the other fields for that particular name.

I know how to create a query to out put the information and I know how to populate the list box. But am having trouble getting them tied together. Here is what I got. Any help would be greatly appreciated.

List box:

<?php

$sql = "select * from data";
$result = mysql_query($sql);
?>
<form>
<SELECT NAME="Select1" SIZE="1">
<option value="-1" selected="selected">All</option>

<?
while ($items = mysql_fetch_array($result))
{
?>

<?
}

?>
</SELECT>

Query:

$result = mysql_query("SELECT * FROM data ORDER BY Name ASC");
if(mysql_num_rows($result)) {

$color = "#D8DBFE";
while($row = mysql_fetch_row($result))
{
print("</tr><tr>");
if($color == "#D8DBFE") {
$color = "#A6ACFD";
} else {
$color = "#D8DBFE";
}

print("<td width=\"7%\" bgcolor=\"$color\"><left>");
print("$row[1]</left></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[2]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[3]</center></td>");
print("<td width=\"7%\" bgcolor=\"$color\"><center>");
print("$row[4]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[5]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[6]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[7]</center></td>");
print("<td width=\"7%\" bgcolor=\"$color\"><center>");
print("$row[8]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[9]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[10]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[11]</center></td>");
print("<td width=\"7%\" bgcolor=\"$color\"><center>");
print("$row[12]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[13]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[14]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[15]</center></td>");
print("<td width=\"7%\" bgcolor=\"$color\"><center>");
print("$row[16]</center></td>");
print("<td width=\"5%\" bgcolor=\"$color\"><center>");
print("$row[17]</center></td>");

}
}
</script>

benbox

-- clicked submit by mistake --

benbox

On your list option line, make sure you have the ' ; ' for a php end of line after each echo bit...
e.g.
<OPTION VALUE="<? echo $items['Name'] ; ?>"><? echo $items['Name'] ; ?></OPTION>

if that doesnt work it needs to be $items["Name"] with "speech marks"

also, if you define it before.. you can print it using a short cut.. (= (equals) is short for print)
e.g.
your while...... {
$name = $items["Name"] ;
?>
<OPTION VALUE="<?=$name?>"><?=$name?></OPTION>
<?
}

also on bits like this, why not use echo.. this will do all the lines for you and you dont need to 'print' each and every line..
you also dont need the " marks in HTML, it isnt 100% compulsary

echo "<td width=7% bgcolor=$color><left>
$row[1]</left></td>
<td width=5% bgcolor=$color><center>
$row[2]</center></td>" ;

etc etc

also make sure your php code is within <? ?> or else it will just be printed to the page as text 😉

Treo

benbox,

thanks for the suggestions but they don't seem to solve my problem.

My problem is that I have a list box with a bunch of names....when a name is slect and the submit but is clisked I want the output of a query using the selected name.