wemustdesign Posted September 28, 2011 Share Posted September 28, 2011 Hi, I have a database that contains the following tables: - State - Town - Zip Code I have a searchbox, when a users submits I want to search all 3 tables for a match. What is the best way of doing this? Link to comment https://forums.phpfreaks.com/topic/248007-msql-search-multiple-tables/ Share on other sites More sharing options...
awjudd Posted September 28, 2011 Share Posted September 28, 2011 Please provide your table structure(s) if / how they relate. If they don't relate then it is the case of a simple UNION of 3 SELECT statements. ~juddster Link to comment https://forums.phpfreaks.com/topic/248007-msql-search-multiple-tables/#findComment-1273481 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.