Jump to content

Archived

This topic is now archived and is closed to further replies.

kellerkind

Join and Order by Problem

Recommended Posts

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

Share this post


Link to post
Share on other sites
Best way is probably just to use a UNION, and the use an ORDER BY on the whole thing.

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.