Biocide Posted January 22, 2007 Share Posted January 22, 2007 I want to be able to search the tables within my database for zipcodes. I have all the zips, county, and cities already entered into tables. I want to be able to type in a zipcode and get the county/city as a result. I want it to work 3 ways always bringing up the other two. Im not sure to how to go about doing this. Any help would be appreciated. Link to comment https://forums.phpfreaks.com/topic/35275-php-searching-tables-with-a-database/ Share on other sites More sharing options...
fenway Posted January 22, 2007 Share Posted January 22, 2007 Just query the appropriate table based on the user's input, and JOIN all 3 tables. Link to comment https://forums.phpfreaks.com/topic/35275-php-searching-tables-with-a-database/#findComment-166748 Share on other sites More sharing options...
Biocide Posted January 23, 2007 Author Share Posted January 23, 2007 The data is in one table, just different columns Link to comment https://forums.phpfreaks.com/topic/35275-php-searching-tables-with-a-database/#findComment-167303 Share on other sites More sharing options...
fenway Posted January 23, 2007 Share Posted January 23, 2007 Then it's easier (though not better) -- you just find all matching rows. Link to comment https://forums.phpfreaks.com/topic/35275-php-searching-tables-with-a-database/#findComment-167471 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.