Jump to content


Photo

stumped...pls check this query


  • Please log in to reply
1 reply to this topic

#1 mgm_03

mgm_03
  • Members
  • PipPipPip
  • Advanced Member
  • 49 posts
  • LocationFort Worth, TX

Posted 27 August 2003 - 03:33 AM

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
Guru?...in my dreams!
Sorry Everybody

----------------------

#2 mgm_03

mgm_03
  • Members
  • PipPipPip
  • Advanced Member
  • 49 posts
  • LocationFort Worth, TX

Posted 27 August 2003 - 04:41 AM

i solved my problem by changing the SELECT statement from

SELECT Co_id ... FROM ...

to

SELECT companies.Co_id ... From...

Guru?...in my dreams!
Sorry Everybody

----------------------




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users