PHP Populate Drop Down Menu

apoch632

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

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

Yeah.

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

Webmonkey

apoch632 wrote: »

Yeah.

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

And what is line 24?

seamus

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>";
}