Jump to content

Archived

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

mgm_03

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 ...

 

to

 


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.