[non-vb]: Why won't this return any results?

[Davey]

PHP Code:

if ($_REQUEST['a'] == "sort2") {
    if ($_REQUEST['str']) {
        $getq = mysql_query("SELECT * FROM `droplist` WHERE drop='" . $_REQUEST['str'] . "' AND viewable='1' ORDER BY id",$dbase);
        if ($getq == NULL) {
            echo("<html><head><title>Monster Drop List - Error!</title><meta http-equiv=\"refresh\" content=\"3;URL=list.php\"></head><body><center>No entries found.<br />Redirecting to main page.</center>$copynotice</body></html>");
            exit();
        } else {
            echo("<html><head><title>Monster Drop List - Filtered drop: " . $_REQUEST['str'] . "</title></head><body><center><table border=\"1\" width=\"80%\"><tr><th>Monster</th><th>Drop</th><th>Server</th></tr>");
            while ($filtered = mysql_fetch_array($getq)) {
                echo("<tr><td><center><a href=\"list.php?a=sort1&str=" . $filtered['monster'] . "\">" . $filtered['monster'] . "</a></center></td><td><center><b>" . $filtered['drop'] . "</b></center></td><td><center><a href=\"list.php?a=sort3&str=" . $filtered['server'] . "\">" . $filtered['server'] . "</a></center></td></tr>");
            }
            echo("</table>Click <a href=\"list.php?a=add\">here</a> to add an entry.<br />Click <a href=\"list.php\">here</a> to view the normal list.</center>$copynotice</body></html>");
        }
    }
} 

Whenever you click on a "drop" item, it returns that there are no entries, yet there are.
The "monster" and "server" items work, just not the "drop" ones.
Any feedback/help would be nice, please.

Dave.

[N!ck]

I think the problem has to do with the:

PHP Code:

if ($getq == NULL) { 

Instead, you should use:

PHP Code:

if (mysql_num_rows($getq) == 0) { 

[Davey]

I fixed it.
Had to put backticks around the word "drop" in the query because drop is a mysql command, lol.