Jump to content

Join and Order by Problem


kellerkind

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
Link to comment
https://forums.phpfreaks.com/topic/22227-join-and-order-by-problem/
Share on other sites

Archived

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

×
×
  • Create New...

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.