need an example of select statment

[PWN_r00t]

i could use a bit of help making a select box from a MySQL database table

// connect of course

select idnumber,location,city from mytable

i want to display in the dropdown the location,city info
and have its value = the id number

<select name='place' value=''>
<option value='idnumber1'>location,city1</option>
<option value='idnumber2'>location,city2</option>
<option value='idnumber3'>location,city3</option>
</select>

my place variable then gets stored into another table

thanks in advance...

[tekky]

Originally posted by PWN r00t
i could use a bit of help making a select box from a MySQL database table

// connect of course

select idnumber,location,city from mytable

i want to display in the dropdown the location,city info
and have its value = the id number

<select name='place' value=''>
<option value='idnumber1'>location,city1</option>
<option value='idnumber2'>location,city2</option>
<option value='idnumber3'>location,city3</option>
</select>

my place variable then gets stored into another table

thanks in advance...

echo "<select name=place value=>\n";
$result = mysql_query("select idnumber,location,city from mytable");
while(list($id, $loc, $city) = mysql_fetch_array($result))
{
     echo "<option value='$id'>$loc,$city</option>\n";
}
echo "</select>\n";

I think that should work.....