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
query multiple tables and display all entries in order
Moderator: General Moderators
Re: query multiple tables and display all entries in order
You could try a join, or a union. This site explains a few ways :
http://articles.techrepublic.com.com/51 ... 50307.html
http://articles.techrepublic.com.com/51 ... 50307.html
Re: query multiple tables and display all entries in order
sorry forgot to reply, thanks 4 that have used union select, works great 