asked on 1/28/2009

String multiple values in WHERE clause

I have a php variable "$song[0]" that is already formatted like this: "Artist - Title".

I need to search for a matching record within a database that stores the artist and titles in seperate columns. To do this, I created this query:

"SELECT s.id, s.artist, s.title, s.picture, s.buycd, s.label, s.composer, s.rating, s.numvotes, s.duration, s.date_played FROM songlist s WHERE ((s.artist & ' - ' & s.title) = '$song[0]') LIMIT 0,1"

The problem is that instead of pulling the correct record, it just pulls the first record in the table. What is the correct way to write this?

PHP MySQL Server

Last Comment

Member_2_4694817

1/28/2009

reb73

1/28/2009

Change the '&' to a '+' as follows -

SELECT s.id, s.artist, s.title, s.picture, s.buycd, s.label, s.composer, s.rating, s.numvotes, s.duration, s.date_played FROM songlist s WHERE ((s.artist + ' - ' + s.title) = '$song[0]') LIMIT 0,1

ASKER CERTIFIED SOLUTION

hielo

1/28/2009

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Daniel Wilson

1/28/2009

Can you echo the assembled SQL statement? Likely it's not getting put together the way you intend ...

MDauphinais1

1/28/2009

ASKER

Thanks!

Bruce Pieterse

1/28/2009

Hi,

Remove LIMIT 0,1 at the end of the SQL statement.

Cheers

Member_2_4694817

1/28/2009

"SELECT id, artist, title, picture, buycd, label, composer, rating, numvotes, duration, date_played FROM songlist
WHERE CONCAT(artist,' - ',title) = '{$song[0]}'"

or better

list($artist, $title) = split(' - ',$song[0], 2);
$result = mysq_query("SELECT id, artist, title, picture, buycd, label, composer, rating, numvotes, duration, date_played FROM songlist WHERE artist='" . mysql_real_escape_string($artist) ."' AND title='" . mysql_real_escape_string($title) . '"';

Open in new window