Retrieving the 25 most recently added entries from all tables in a MySQL databas

Posted on 16th Feb 2014 07:03 pm by admin

Hello,

The code below works great. It creates a table that shows the 25 most recently added tables to a MySQL database called "sitefeather."

Each one of these tables has the following structure:

Code: id INT(11) NOT NULL auto_increment, site VARCHAR(1000) NOT NULL, action1 BIGINT(9) NOT NULL, action2 BIGINT(9) NOT NULL, createddatetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(id), UNIQUE (site)
I would like to echo a list of "site" and "CURRENT_TIMESTAMP" for the 25 most recently added rows, regardless of which table they are in. This may be tricky since the number of tables is variable. Someone advised me that I would have to use a query involving INFORMATION_SCHEMA.TABLES. How can I do this?

Thanks in advance,

John

Code: echo "<table class="samples">";
$index = mysql_query("select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='sitefeather' order by CREATE_TIME desc limit 25");
while ($row = mysql_fetch_array($index))
{
echo '<tr><td><a href="sitesearch.php?find='.urlencode($row['TABLE_NAME']).'&searching=yes&search=search">'.$row['TABLE_NAME'].'</a></td></tr>';

}
echo "</table>";

Your Answer:

Login to answer

Other forums

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

switch not getting value
what am i doing wrong?
i want to populate the country list according to the category
i want to

Login Control?!
I have a Web Site that uses the login control also I have set the destinationurl to the page I want

getting Vars to pass to next page.
Hello all,
I have a confusing situation on my hands, i am a member of a gaming community and we

sapgui f4 help last search
I know this has to be simople. One user (maybe more) does not have the "last search saved" from the

How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.

H

remove innitial

and

tags
i am using tiny_mce as a text editor for my CMS.
buy now the problem is it add <p>

Wierd echo error?
Hi, i got the most wierd php error ever and i don't know why..
Code: echo "<t

What am I missing here? Help!
Hello all!. I can't seem to get this working right. Well - it renders right, but something is goin

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl