kellerkind Posted September 27, 2006 Share Posted September 27, 2006 Hi, I'm new to join statements and it would be great if anyone could help me. I did some tutorials but I'm not sure if i can do what i want to do with join.[u]PROBLEM[/u]I have a variable number of tables called "newsposts" (newsposts1, newsposts2, newsposts3...)In each of these tables I have a column with "postdate".I want to get the 10 latest entries from all "newsposts" tables.[u]SOLUTION?[/u]So my idea was to first create an array with all names of "newsposts" tables and after that Join all these tables and use order by "postdate" with a limit of 10 to display the latest data from all "newsposts" tables.[u]QUESTION[/u]Could it work like this and do you have an example of how such a join statement would look like?Thanks a lot, Jay Link to comment https://forums.phpfreaks.com/topic/22227-join-and-order-by-problem/ Share on other sites More sharing options...
fenway Posted September 27, 2006 Share Posted September 27, 2006 Best way is probably just to use a UNION, and the use an ORDER BY on the whole thing. Link to comment https://forums.phpfreaks.com/topic/22227-join-and-order-by-problem/#findComment-99752 Share on other sites More sharing options...
kellerkind Posted September 27, 2006 Author Share Posted September 27, 2006 Hey cool thanks a lot!I did some weird stuff with 2dimensional arrays and have a couple of querries now but at least it works but I give union a try.Muchas gracias! Link to comment https://forums.phpfreaks.com/topic/22227-join-and-order-by-problem/#findComment-99804 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.