Guldstrand Posted February 26, 2011 Share Posted February 26, 2011 I need some help on how to search in two different mysql tables, and then show the results sorted/ordered by the tables. RESULTS: Tabel 1 # ... # ... Tabel 2 # ... # ... Thanks in advance! Quote Link to comment https://forums.phpfreaks.com/topic/228966-search-in-two-different-mysql-tables/ Share on other sites More sharing options...
jcbones Posted February 26, 2011 Share Posted February 26, 2011 Look Here Quote Link to comment https://forums.phpfreaks.com/topic/228966-search-in-two-different-mysql-tables/#findComment-1180163 Share on other sites More sharing options...
Guldstrand Posted February 26, 2011 Author Share Posted February 26, 2011 Look Here Thanks for the fast reply... I have already looked at that page, but i couldn´t understand much. Quote Link to comment https://forums.phpfreaks.com/topic/228966-search-in-two-different-mysql-tables/#findComment-1180165 Share on other sites More sharing options...
jcbones Posted February 27, 2011 Share Posted February 27, 2011 Sorry, without more info, that is all I can give you. Quote Link to comment https://forums.phpfreaks.com/topic/228966-search-in-two-different-mysql-tables/#findComment-1180220 Share on other sites More sharing options...
sasa Posted February 27, 2011 Share Posted February 27, 2011 use two query or use UNION of two query Quote Link to comment https://forums.phpfreaks.com/topic/228966-search-in-two-different-mysql-tables/#findComment-1180390 Share on other sites More sharing options...
Guldstrand Posted February 27, 2011 Author Share Posted February 27, 2011 use two query or use UNION of two query I have thought about using UNION, but i´m not sure how. Any chance of an example code? Quote Link to comment https://forums.phpfreaks.com/topic/228966-search-in-two-different-mysql-tables/#findComment-1180416 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.