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.
08-16-2003, 12:50 AM
[non-vb]: Why won't this return any results?
Threaded Mode