$host = "webdev.iyaserver.com";
$userid = "<youruserid>";
    $userpw = "<yourpw>";
        $db = "<database name>";

            $mysql = new mysqli(
            $host,
            $userid,
            $userpw,
            $db
            );

            if($mysql->connect_errno) {
            echo "db connection error : " . $mysql->connect_error;
            exit();
            }

            $sql = "SELECT * FROM genres ORDER BY genre";

            $results = $mysql->query($sql);

            if(!$results) {
            echo "SQL error: ". $mysql->error;
            exit();
            }
            while($currentrow = $results->fetch_assoc()) {
            echo "<option>" . $currentrow['genre'] . "</option>";
            }