Here's my SQL:
$query = mysqli_query($db, "SELECT * FROM chat WHERE to = '0' ORDER BY id DESC LIMIT 0,30");
And my table looks like this:
Why does it not find it? If I remove the WHERE to = '0' it works fine.
Asked
Active
Viewed 38 times
0
prk
- 3,643
- 6
- 15
- 26
-
`WHERE TRIM(to) = '0'` Whitespaces probably – Lukasz Szozda Oct 06 '15 at 23:30
-
2Always consult the manual before writing MySQL https://dev.mysql.com/doc/refman/5.6/en/keywords.html – Funk Forty Niner Oct 06 '15 at 23:31
-
Is your to `string`? or `int`? – aldrin27 Oct 06 '15 at 23:32
-
@aldrin27 It's a string. – prk Oct 06 '15 at 23:32
-
comments #1 and #3, won't do a difference. It's #2 OP needs to worry about. – Funk Forty Niner Oct 06 '15 at 23:32
-
Yeah, it worked, thanks @Fred-ii-! – prk Oct 06 '15 at 23:34