Is anything wrong with this query?

[Christopher]

SELECT * FROM content WHERE for='NEWS' ORDER BY id DESC LIMIT 3

Says there is a parse error on line 13... Whole line:


$get_news = mysql_query("SELECT * FROM content WHERE for='NEWS' ORDER BY id DESC LIMIT 3")) or die(errorMsg());

[Christopher]

Nevermind, just got it...

I put an extra ")" at the end...

[Christopher]

Arg, the parse error is gone, but there is something wrong with the query... Help?

[Dusty]

"For" is a MySQL reserved word, you can't use it without quoting.

SELECT * FROM `content` WHERE `for` LIKE 'NEWS' ORDER BY `id` DESC LIMIT 3

[Christopher]

Originally posted by Dusty
"For" is a MySQL reserved word, you can't use it without quoting.

SELECT * FROM `content` WHERE `for` LIKE 'NEWS' ORDER BY `id` DESC LIMIT 3
Ahh... Well, I think I'll just rename the for to something else, easier...

And to do the condition, you have to do "LIKE 'NEWS'" ? Or is my
"='NEWS'" alright?

EDIT Nevermind, works like a charm! Thanx again Dusty.

[Dusty]

= will work to for that, too. If ever you use % or _ in your matching, though, you'd have to use LIKE.

[Christopher]

lol, one last question...

How do you return results where a column is NULL?

I tried " WHERE pid='' " (empty single quotes) but it didn't work...

[Dusty]

pid=NULL

[Christopher]

Well, that didn't work. So I took it upon myself to go out on the big web and find the answer because I didn't want to look like an idiot coming here asking question after question.

Observations: Do not use pid=NULL, you use pid IS NULL.

Hehe, I did it all on my own!

:p :biggrin2: :D