How to have 2 WHERE clauses in a SELECT

[Anon]

How do I get this query:

SELECT * FROM playernews WHERE player='$playerid'

to also check for WHERE news=0?

for example,
SELECT * FROM playernews WHERE player='$playerid' AND news=0

but that gives a syntax error.

[Anon]

It's giving you a syntax error because the query should read:

SELECT * FROM playernews WHERE player='$playerid' AND news='0'

Notice the single quotes.

[Anon]

i have tried that to no avail 🙁

[Anon]

read is a reserved word. Rename the field and try again :-)

[Anon]

Thanks 🙂 that fixed it.