retrieve data from mysql database to display in a dropdown box with php

**georgewashinton** · May 23 '07, 03:01 AM

[code=html]<html>
<body>

<?php

$con=mysql_conn ect("localhost" ,"root","")
or die('Could not connect: ' . mysql_error());

mysql_select_db ("my_db", $con);

$result = mysql_query("SE LECT username FROM users")
or die("Invalid Query: " .mysql_query()) ;

echo '<label>Select username:</label>';
echo '<select id="username" name="username" >';
echo '<option value="">Select </option>';

while ($row = mysql_fetch_ass oc($result))
{
$va = $row['username'];
echo "<option value='$va'>$va </option>";
}
echo '</select>';

mysql_close($co n);
?>

</body>
</html>
[/code]

[Please use CODE tags when posting source code. Thanks! --pbmods]

hope it would help you.

retrieve data from mysql database to display in a dropdown box with php

retrieve data from mysql database to display in a dropdown box with php

Comment