Recent uploaded Galleries

[Zeldamo]

<?php  
$host   = 'localhost'; 
$dbUser = 'username';   
$dbPass = 'password'; 
$db = 'database'; 
mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());


$result = mysql_query("SELECT max(id)-1 as id,cat,bigimage FROM pp_photos order by id DESC LIMIT 1" ) or die(mysql_error());   
while($row = mysql_fetch_array( $result )) {	
print "<a href=\"/images/showgallery.php?cat=" . $row['cat'] . "\"><img src=\"/images/data/" . $row['cat'] . "/thumbs/" .  $row['bigimage'] . "\"></a>";
}

?>

Above script extract latest uploaded gallery link and thumb. Anyway I could extract 5 latest instead of one? Oh, if possible, a way to exclude a particular cat (category). I've tried multiple ways but failing all.

Thank you in advance

[DJDarkViper]

You bet!

See where you got:
$result = mysql_query("SELECT max(id)-1 as id,cat,bigimage FROM pp_photos order by id DESC LIMIT 1" ) or die(mysql_error());

use this instead:

$result = mysql_query("SELECT max(id)-1 as id,cat,bigimage FROM pp_photos order by id DESC LIMIT 5" ) or die(mysql_error());

Just updated the "LIMIT" argument in the SQL call. You already have a while loop to go through all results returned, so everything else is just fine


Have fun!

[Zeldamo]

Thank you, sir! it worked!

[TheRACK]

DESC LIMIT # ^^

Glad you got the help you wanted.