Possible reason why this simple select won't work.

[Bootsman123]

I have this selec-statement:

$query = "SELECT * FROM comments WHERE pic_url = `$pic` order by date DESC";
$result = mysql_query($query) or die ("Failed!");

and it's keep getting failed. In 'pic_url' filenames of pictures are stored, so things like this: "abc 123 ABC123.jpg" and $pic contains the same things like that. Why won't it work then? I have stored multiple things in the database so, it should select them. Even if I delete these `` it won't work either.

[tijger]

hey, Bootsman123,

this maybe works:

$query = "SELECT * FROM comments WHERE pic_url = '$pic' order by date DESC";
$result = mysql_query($query) or die ("Failed!");

you are using ` (backtick) but you have to use ' (quote). i think that is what you're doing wrong.

good luck.
greetings, tijger

[Bootsman123]

Thanks a lot, it worked! Stupid of me that I didn't tried that.