Fill drop down menu with sql data help!

[benji87]

Hey all could someone please tell me why this code does not fill the drop down menu with data drawn from a sql database!? It executes without error but not data....

[code]
<?php
include 'db.php';
$query= mysql_query("SELECT * FROM ssrfc_images") or die (mysql_error());
$result = mysql_query($query);

echo '<select name="images" size=1>';
while($row = mysql_fetch_array($result)){
        echo '<option value="' . $row['id'] . '">' .  $row['image'] . '</option> \n';
    }


echo '</select>';

?>[/code]

[benji87]

anyone?

[Atanu]

$query= mysql_query("SELECT * FROM ssrfc_images") or die (mysql_error());
$result = mysql_query($query);

write this only:
$query="SELECT * FROM `ssrfc_images`";
$result = mysql_query($query);

the code may execute.try this.