Mysql Query Mistake

[Napster]

I am getting an error for this mysql query. What is wrong with it

$loop = mysql_query("SELECT * FROM forumst WHERE forumid='$id' AND lock!='1' AND tack!='1'");

[Weedpacket]

If forumid, lock, or tack are numeric fields, then the values shouldn't be quoted.

[Napster]

Ok, I tried

$loop = mysql_query("SELECT * FROM forumst WHERE forumid=$id AND lock=0 AND tack=0");

and

$loop = mysql_query("SELECT * FROM forumst WHERE forumid='$id' AND lock=0 AND tack=0");

i even tried

$loop = mysql_query("SELECT * FROM forumst WHERE forumid='$id' AND lock!='1' AND tack!='0'");

And it still doesn't work. It worked when it was

$loop = mysql_query("SELECT * FROM forumst WHERE forumid='$id'");

but i need the last two where statments

[djKale]

Maybe it's something dumb like the wrong/misspelled field name...like TACK or Lock (case sensitive), wrong variable name, Wrong table name, etc. Maybe it is a problem elsewhere that points to the sql query...

Looks good to me otherwise. What error are you getting?

Kale

[Weedpacket]

See this post and the link quoted therein.

[Napster]

i get

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/myforum/public_html/forum.php on line 48

that only appeared when i added the last two statements

[Napster]

I fixed it, lock is a word you cant use as a mySQL database or column name