Jump to content

SQL Error


hansman

Recommended Posts

you're not joining the target tables Companies and Zips, so you get every possible combination. you need to add a WHERE condition tying together Companies and Zips, like

 

SELECT * FROM `Companies`, `Zips` WHERE Companies.ZipCodes = Zips.ZipCodes AND Zips.ZipCodes LIKE CONVERT(_utf8 '%$zip%' USING latin1) COLLATE latin1_german2_ci ORDER BY Rank ASC

 

Link to comment
https://forums.phpfreaks.com/topic/120754-sql-error/#findComment-622381
Share on other sites

BlueSky, That is not returning anything.

 

Barand- How would i go upon using a JOIN, in the SQL statement i have provided.

I have a table of companies, with a field full of zipcodes.

 

and i have  table of zip codes, each zipcode has a town state etc..

 

When a user searches there own zip code, compnay info will come up, and information about the zip code will come up.

Link to comment
https://forums.phpfreaks.com/topic/120754-sql-error/#findComment-622397
Share on other sites

Archived

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

×
×
  • Create New...

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.