Jump to content

Archived

This topic is now archived and is closed to further replies.

AncientSage

SQL Error : 1054

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.