HELP! Problem with a simple line. HELP!

Originally posted by snyx
HELP! Here is the orignal code

$pop1 = $DB_site->query('SELECT title,threadid,views FROM thread ORDER BY views DESC LIMIT 1');

Im trying to block out all replys from showing up from forum 41
this is what I tried, but its not working

$pop1 = $DB_site->query('SELECT title,threadid,views FROM thread WHERE forumid<>41 ORDER BY views DESC LIMIT 1');

so what else can I do?

snyx

try a = in the query use equal sign and the ' ' around number as follows should work fine

$pop1 = $DB_site->query('SELECT title,threadid,views FROM thread WHERE forumid<>='41' ORDER BY views DESC LIMIT 1');