nothing displays from in list

[nevx009]

i need help with this script , i think i may have gone about it the wrong way , nothing is being displayed in the select when i view , there's defienely data in the database genre table and it connects ok, i think it's with the quote ' and " ,i'm using , please explain how to use them properly , thanks

<select name="genre">
   <?
        $db=mysql_connect("localhost");
        mysql_select_db("vinyldealers",$db);
        $query="SELECT * FROM genre";
        $result=mysql_query($query);

    while($record=mysql_fetch_assoc($result)) {
        echo "<OPTION VALUE='".$record["genreID"]."'>" .$record["name"] ;
    }

?>    </select>

[Derokorian]

First, Welcome to PHPBuilder.com! Please use the boards [NOPARSE]

[/NOPARSE] as it makes your code much easier to analyze and read.

Second you are not checking if the connection was successful, if the db selection worked or if the query itself worked.

Thirdly, you should no longer be using the mysql extension and instead should be using mysqli or PDO