Page 1 of 1

query multiple tables and display all entries in order

Posted: Wed Feb 03, 2010 6:50 am
by me666
hi, i have been working on a little project, but want to make it easier to view results online. i need to be able to query several tables and display the results from all tables queried in order of date and time. i can do this all fine but only querying 1 table at a time and displaying on 1tables results. does anyone know how i might do this?
thanks

Re: query multiple tables and display all entries in order

Posted: Wed Feb 03, 2010 7:26 am
by aravona
You could try a join, or a union. This site explains a few ways :

http://articles.techrepublic.com.com/51 ... 50307.html

Re: query multiple tables and display all entries in order

Posted: Wed Mar 03, 2010 2:27 pm
by me666
sorry forgot to reply, thanks 4 that have used union select, works great :)