Load last 3 items from database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Livengood
Forum Newbie
Posts: 11
Joined: Tue Nov 01, 2011 2:48 pm

Load last 3 items from database

Post by Livengood »

How would you load the last three items from a database using php?
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: Load last 3 items from database

Post by Celauran »

Code: Select all

SELECT whatever FROM tablename ORDER BY id DESC LIMIT 3
User avatar
twinedev
Forum Regular
Posts: 984
Joined: Tue Sep 28, 2010 11:41 am
Location: Columbus, Ohio

Re: Load last 3 items from database

Post by twinedev »

Code: Select all

$aryData = array();
$rsData = mysql_query('SELECT * FROM tblName ORDER BY fldName DESC LIMIT 3');
if ($rsData && mysql_num_rows($rsData) > 0) {
    while ($aryData[] = mysql_fetch_assoc($rsData));
    array_pop($aryData); // Last item will be FALSE, not a record
    $aryData = array_reverse($aryData);
    mysql_free_resouce($rsData);
}
unset($rsData);

// $aryData = Last three results
or another way

Code: Select all

$aryData = array();
$rsData = mysql_query('SELECT * FROM tblName ORDER BY fldName DESC LIMIT 3');
if ($rsData) {
    $intRows = mysql_num_rows($rsData)
    if ($intRows>0) {
        for($t=$intRows-1; $t>=0; $t--) {
            $aryData[$t] = mysql_fetch_assoc($rsData);
        }
        mysql_free_resouce($rsData);
    }
}
unset($rsData);

// $aryData = Last three results
Livengood
Forum Newbie
Posts: 11
Joined: Tue Nov 01, 2011 2:48 pm

Re: Load last 3 items from database

Post by Livengood »

Thanks guys, thats helps alot with this project :D
Post Reply