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