issya Posted March 28, 2007 Share Posted March 28, 2007 Hello, I was wondering if someone may be able to help with a problem. I am trying to make a query work and I am having troubles doing so. I would like to JOIN to databases by the zip code column in each and also have the query perform a search on text I entered in. I am putting the end result into PHP, but I am just having trouble with the code. The below code works fine to bring back a general query with all records on it. select consumer.email, zip.county FROM consumer, zip WHERE consumer.zip = zip.zip How would I specify that I just want one zip code on the above query? I tried using LIKE 33764, but it does not work. Also, the code below is what I would like the above code to look like, the only difference is that the above would be joining 2 tables. select * from state WHERE MATCH(county) AGAINST ('%$trimmed%' IN BOOLEAN MODE) order by county Any help on this would be greatly appreciated. Jason Link to comment https://forums.phpfreaks.com/topic/44624-solved-mysql-join-and-search/ Share on other sites More sharing options...
issya Posted March 28, 2007 Author Share Posted March 28, 2007 Well, I got the answer and I got it to work. Now I am adding a BETWEEN to the end of it and it is pulling back random results that are not right. Am I doing something wrong? select consumer.email, zip.county FROM consumer, zip WHERE consumer.zip = zip.zip and MATCH(zip.county) AGAINST ('%$trimmed%' IN BOOLEAN MODE) AND consumer.income BETWEEN '$trimmed2' AND '$trimmed3' Link to comment https://forums.phpfreaks.com/topic/44624-solved-mysql-join-and-search/#findComment-216737 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.