PHP Populate Drop Down Menu

apoch632 · 05-03-2008 06:27PM #1

Hey

I'm trying to populate a drop down box from a MySQL Database
Can anyone see whats wrong with this code

$query="SELECT rate FROM tariff_rate";
$result=mysql_query($sql);

$options="";

echo $row['rate'];

while ($row=mysql_fetch_array($result)) {
$options = <option value=".$row['rate'].">"<php? echo ".$row['rate']."?>"</option>;
}

seamus · 05-03-2008 06:31PM

Few syntax errors and missing tags in there.

Needs to look like this:

while ($row=mysql_fetch_array($result)) {
$options = <option value="<?php echo ".$row['rate']."?>"><?php echo ".$row['rate']."?></option>;
}

See the difference?

apoch632 · 05-03-2008 06:39PM

Yeah.

Its now throwing this error
Parse error: syntax error, unexpected '<' in blahblah on line 24

Webmonkey · 05-03-2008 08:34PM

apoch632 wrote: »

Yeah.

Its now throwing this error
Parse error: syntax error, unexpected '<' in blahblah on line 24

And what is line 24?

seamus · 05-03-2008 08:45PM

D'oh, totally read the code wrong.

Should look like this:

while ($row=mysql_fetch_array($result)) {
$options .= "<option value=\"".$row['rate']."\">".$row['rate']."</option>";
}

PHP Populate Drop Down Menu

Comments