Hi,
I am having problems with my query trying to call a list of interests.
When someone signs up too the site they choose 7 different interests
from a list and it can be in any different configuration. I am having a
hard time getting it to query, and amy getting this error message:
SELECT
clients.CUserName,clients.CFirstName,clients.CLastName,clients.CCity,clients.CGender,clients.CMarital,clients.CCommunity,clients.CHeight,clients.CKids,clients.CBody,clients.CEducation,clients.CChurch,clients.CEmail,i1,i2,i3,i4,i5,i6,i7
FROM clients,interests WHERE (CCity LIKE '%' AND CHeight LIKE '%' AND
CKids LIKE '%' AND CAge LIKE '%' AND CMarital LIKE '%' AND Interests
LIKE ('' OR '' OR '' OR '' OR '' OR '' OR '') AND clients.CUserName =
interests.CUserName) ORDER BY CCity, CLastName
Warning: Supplied argument is not a valid MySQL result resource in
c:\phpweb/searchresults1.php on line 462
Found profiles that matched your search criteria.
Here is my original code for the query.
$query = "SELECT
clients.CUserName,clients.CFirstName,clients.CLastName,clients.CCity,clients.CGender,clients.CMarital,clients.CCommunity,clients.CHeight,clients.CKids,clients.CBody,clients.CEducation,clients.CChurch,clients.CEmail,i1,i2,i3,i4,i5,i6,i7
FROM clients,interests
WHERE
(CCity LIKE '$Qcity'
AND CHeight LIKE '$Qheight'
AND CKids LIKE '$Qkids'
AND CAge LIKE '$Qage'
AND CMarital LIKE '$Qmarital'
AND Interests LIKE ('$i1' OR '$i2' OR '$i3' OR '$i4' OR '$i5' OR '$i6'
OR '$i7')
AND clients.CUserName = interests.CUserName)
ORDER BY CCity, CLastName
Thanks in advance!
Kelly
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
