Jump to content


This topic is now archived and is closed to further replies.


stumped...pls check this query

Recommended Posts

I have 3 tables:

companies, services, company_service (many to many relation)


this query works fine (meaning the query returns a result) except when I include \"Co_ID\" in the SELECT statement, the query returns no result...what am I missing. Co_ID is an integer and primary key for the companies table.


$query = "SELECT Co_ID, company, address, city, state, zip

FROM companies, company_service WHERE companies.Co_ID=company_service.Co_ID 

AND company_service.service_id=$svid ORDER BY zip";


any thoughts are greatly appreciated.

Thanks, a Noobie

Share this post

Link to post
Share on other sites

i solved my problem by changing the SELECT statement from


SELECT Co_id ... FROM ...




SELECT companies.Co_id ... From... 

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.