Hi,
I am trying to populate a drop down menu from a mysql database,
below is a portion of the script:
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM drivers";
mysql_close();
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
<select name="Name">
<?php
$i=0;
while ($i < $num) {
$field3=mysql_result($result,$i,"Name");
echo "<option value="$i">$field3"</option>"; //line 41 in the script
$i++;
}
?>
</select>
I am getting the following error:
Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in /usr/local/www/apache22/data/data/editdriver.php on line 41
Please help
