Programming Forums > Web Development and Design > PHP

foxcity911 · Jul 28th, 2005, 4:06 AM

ive made a database and php script to access and search my songlists. my php code to select items from the DB looks like this:

(Toggle Plain Text)

$query = "SELECT * FROM tracks WHERE artist like '%$artist%' AND track like '%$songname%' AND genre like '%genre%'";

everything works perfectly smoothly exept the AND [genre like '%genre%'";] part. to me it seems that and can't be used twice in a row as track works correctly with it.

whats the correct way of 'selecting' 3 or more items [WHERE] in a query?

thanks alot

foxcity911 · Jul 28th, 2005, 4:42 AM

ah damnit, nobody bother replying to this. solved. i didn't use genre as a variable.
'%$genre%'

Jul 28th, 2005, 4:06 AM	#1
foxcity911 Programmer Join Date: Jun 2005 Location: Queensland Posts: 37 Rep Power: 0	Multiple Condition Where Clause ive made a database and php script to access and search my songlists. my php code to select items from the DB looks like this: (Toggle Plain Text) $query = "SELECT * FROM tracks WHERE artist like '%$artist%' AND track like '%$songname%' AND genre like '%genre%'"; $query = "SELECT * FROM tracks WHERE artist like '%$artist%' AND track like '%$songname%' AND genre like '%genre%'"; everything works perfectly smoothly exept the AND [genre like '%genre%'";] part. to me it seems that and can't be used twice in a row as track works correctly with it. whats the correct way of 'selecting' 3 or more items [WHERE] in a query? thanks alot

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jul 28th, 2005, 4:42 AM	#2
foxcity911 Programmer Join Date: Jun 2005 Location: Queensland Posts: 37 Rep Power: 0	ah damnit, nobody bother replying to this. solved. i didn't use genre as a variable. '%$genre%'

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > PHP

Multiple Condition Where Clause