SQL Error : 1054

[AncientSage]

I'm attempting to use this query via PHP:

[code]"SELECT song_name, song_author, song_genre 
FROM jukebox
WHERE " . $song_selected . " = song_filename"; //Note, this line.[/code]

All good up 'till that last line, I tried switching it around (where the variable is) and such, but it keeps telling me unknown column, or SQL Error 1054.

Now, I'm not too familiar with the WHERE clause, but if I want to tell SQL only to select results based on a row in song_filename, how would I do that with the WHERE clause? 'cause my method doesn't appear to be working.

[shoz]

The $song_selected string should be surrounding by quotes

[code]
"SELECT song_name, song_author, song_genre 
FROM jukebox
WHERE '" . $song_selected . "' = song_filename";
[/code]

[AncientSage]

I always miss something so simple. >.<

Anyway, thanks for the help.