display the last 10 entries

brauchii

I have some kind of code that i would like to change in a way to discplay the last 10 entries

for($i=0;$i<count($data);$i++){
entityHTML($data[$i]);
if($mode=="edit")$url="edit.php?mode=edit&adtype=".$adtype."&id=".$data[$i]["id"]."&owner=".$data[$i]["owner"];
else $url="detail.php?adtype=".$adtype."&id=".$data[$i]["id"];
($i%2)?$bgcolor=$design["tr_color"]:$bgcolor="white";
$pdate=explode("-",$data[$i]["date"]);
(is_file($epath."/img/flags/".$data[$i]["country"].".gif"))?$flag=" ":$flag="";
?>

so far i was only able to display the first 10 entries. bUt i am not sure how i can go backwards.

Does anybody have an idea? Thank you in advance

barand

That is going to depend on the source and structure/content of your original data

Weedpacket

 for($i=0;$i<count($data);$i++){

So instead of starting at the beginning and counting upwards, start at the end and count downwards.

bpat1434

for($i=count($data)-1; $i>=0; $i--){

brauchii

for($i=count($data)-1; $i>=30; $i--){

Thank you. This is getting somewhere now. The only problem is that I need to adjust the $i>30 depsning on how many entries I have in the database.

Is there a way that I can set this to max 10 displays no matter how many entries I have so that i don't have to adjust the code AND that I have the same number of entries in both tables?

laserlight

The only problem is that I need to adjust the $i>30 depsning on how many entries I have in the database.

If you are using SQL to query the database, you may want to consider selecting the last 10 entries in the SQL statement itself.

brauchii

I was trying to do that. But the program I am using has some weired coding in it.

function getFront($adtype){
global $dbtables,$str_common,$rlimit;
?>
<br>
<div id="menu">
<b><?=$str_common["newad"]?></b>
<br>
<?=$str_common[$adtype]?>
</div>
<?
$data=getDBData($adtype,""," ORDER BY id DESC LIMIT 10 ");
showList("detail",$adtype,$data);
?>
<div id="menu">
<b><?=$str_common["sum"]?>: <?=count($data)?></b><br>
</div>
<?
}

and even when I change a limit or want to count backwards..... it just doesn't work.

This is why I was hopeing I might be able to right this extra piece of code.

bpat1434

$data=getDBData($adtype,""," ORDER BY id DESC LIMIT 10 ");

THat takes the ids and lists them from highest to lowest (Descending order) which is what you want right? So where's the problem?

Or do you want it the other way? Change DESC to ASC (ascending) and it should reverse the order....