Display column from database in dropdown

[anton_1]

Thanks for your time guys:

 

 

 

$data = @mysql_query("select * from names");

echo "<p>Select a Name: n";

echo "<Select Name="ID">n";

while ($row = mysql_fetch_assoc($data))

{

$ID = $row['ID'];

$year = $row['name'];

echo "<option value=$ID>$namen";

}

echo "</select>n";

echo "</p>n";

 

[anton_1]

it's complaining about this line

 

 

echo "<Select Name="ID">n";

[guyfromfl]

it's complaining about this line

 

 

echo "<Select Name="ID">n";

 

What is it's gripe?  Can you copy the error?

[cunoodle2]

it's complaining about this line

 

 

echo "<Select Name="ID">n";

 

You need to escape the double quotes in the echo statement like this..

echo "<Select Name=\"ID\">n";

OR you can do this..

echo '<Select Name="ID">n';

 

[guyfromfl]

cunoodle is right...that should do it..