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? Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/248007-msql-search-multiple-tables/#findComment-1273481 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.