SQL Dropdown Box

[JamesU2005]

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.

 

[toString]

Post what you have first!

 

[edwardcasbon1]

Id say that you can pretty much have any content in a select drop down.

Just do your query/ies in php and get the results, and then display whatever data you want to display between the <option> tags. e.g.

<option><?php echo $res['data']; ?></option>

That should do the trick.

 

[Freakish_05]

Asuming you're using PHP and MySQL
I had trouble with this a few weeks ago. Here's what worked for me:

<select name="dropdown">
<?php do { ?><option value="<?php echo [B]$option_value[/B] ?>"><?php echo [B]$option_text[/B] ?></option><? } while ([B]$Query_Row[/B] = mysql_fetch_assoc([B]$Query[/B])); ?>
</select>

Its a bit primative, but it works. The bold bits are the parts which need changing.
$Query is obviously your SQL query. You also need to have the following in the php code somewhere near (but underneath ) $Query:

$Query_Row = mysql_fetch_assoc($Query);

HTH

 

[JamesU2005]

Thanks for your help guys.

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

 

[psyr33n]

The do/while syntax is indeed primitive, just opt for the standard while syntax:

<?php do { ?><option value="<?php echo $option_value ?>"><?php echo $option_text ?></option><? } while ($Query_Row = mysql_fetch_assoc($Query)); ?>

will become

<?php

/*
* Example query:
* SELECT `option`, `value` FROM `table`
*/

while($row = mysql_fetch_assoc($query)
	echo '<option value="', $row['value'], '">', $row['option'], '</option>';

?>

no point escaping for such small output.

 

[Beansprout]

A do{} will also fail horribly if there are no rows returned for whatever reason, and also involves the unnecessary repetition of the $Query_row line

 

[JamesU2005]

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.

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

 

[psyr33n]

You don't want to be printing a <select> in a loop, naturally:

<select size='1' name='drop'>

<?php

while (!$rs->EOF)
{
 echo '<option value = \'phonemodel\'>', $phones->value, '</option>';
 $rs->MoveNext();
}

?>

</select>

 

[JamesU2005]

Problem solved!

Thanking you all kindly.