|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
December 19th, 2006, 03:55 AM
|
|||
|
|||
|
SELECT syntax LOVE
Need Help!!!
i would like to display records for people that loves 'A' and loves 'B'... i'm having problem with this syntax... SELECT * FROM loves WHERE loveID = 'A' AND loveID = 'B' tried using the syntax below... SELECT lovesFROM kemahiran WHERE loveID IN ('A', 'B') ..but it returns anyone who loves 'A' or 'B'.... ..instead i wanna display people who love both 'A' & 'B'... please help....thanx in advance.....
|
|
#2
December 24th, 2006, 01:52 AM
|
||||
|
||||
|
database query
I have a feeling that your problem may not be how to write the right query, but that your table schema isn't adequate for your goals. How does the field "loveID" store the possibly multiple values?
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > SELECT syntax LOVE |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
