stumped...pls check this query

[mgm_03]

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

[mgm_03]

i solved my problem by changing the SELECT statement from

 

SELECT Co_id ... FROM ...

 

to

 

SELECT companies.Co_id ... From...