SQL Dropdown Box

JamesU2005 · 11 Mar 2007 at 18:21

Just wondered if its possible to have data from a database presented in a drop down box using SQL and PHP.

I'm sure it's a SELECT statement and Print but can't quiet work out how.

Thanks for any help.

JamesU2005 · 11 Mar 2007 at 19:31

Thanks for your help guys.

Will give it a go and post my results when I have em.

JamesU2005 · 11 Mar 2007 at 21:44

Nearly there but they print as separate drop downs for each one.

I know its something to do with the Movenext but again my lack of knowledge fails me.

Code:

while (!$rs->EOF)
{
print "<select size='1' name='drop'>";
print "<option value = 'phonemodel'>$phones->value</option>";
print " </select>";
$rs->MoveNext();
}

JamesU2005 · 11 Mar 2007 at 21:53

Problem solved!

Thanking you all kindly.