need search query help...
Posted: Wed Jul 06, 2005 3:48 pm
this query worked fine.
the only time this doesn't work is when I'm seaching a business name since the business names are in the business table and not the cusotmer table. i made this query which I thought would work.
the query returns results, but not acurate ones.
the customer table references the business table at business_id. can anyone tell me what I'm doing wrong or how to fix this.
Code: Select all
"e;SELECT c.*, b.business_name FROM customer_contact_info c, business b WHERE c.$srtMe
LIKE'%$question%' AND c.business_id = b.business_id ORDER BY $srtMe ASC LIMIT $page_a,$page_b"e;the only time this doesn't work is when I'm seaching a business name since the business names are in the business table and not the cusotmer table. i made this query which I thought would work.
Code: Select all
SELECT c.*, b.business_name FROM customer_contact_info c, business b WHERE b.$srtMe
LIKE'%$question%' AND c.business_id = b.business_id ORDER BY $srtMe ASC LIMIT $page_a,$page_b"e;the customer table references the business table at business_id. can anyone tell me what I'm doing wrong or how to fix this.