L'affichage est limité a 5 id, avec un lien pour afficher les 5 id suivant,etc ainsi de suite..
<?php if ($ax=="list")
{
if($sub_cat != 0)
{
$topic2_result = MySQLQuery("SELECT id,sub_cat,name FROM links_cat WHERE id=$sub_cat", $QueryError_Email,$QueryError_Browser);
while($topic2_row = mysql_fetch_array($topic2_result))
{
$id2=$topic2_row["id"];
$sub_cat2=$topic2_row["sub_cat"];
$name2=$topic2_row["name"];
}
$trail="<a href=\"fav.php?ax=list&sub=$id2&cat_id=$id2\">$name2</a> > $name";
}
else
{
$trail=$name;
}
echo "<p class=\"bodylgbold\">$name</p>";
echo "<p class=\"bodysm\"> <a href=\"fav.php\">Home</a> > $trail</p>";
echo "<p class=\"bodymd\">$dsc</p>";
if(!isset($start)){$start = 0;}
$sql_rqst="SELECT * FROM links WHERE cat_id=".$_GET["cat_id"]." AND approved='yes' ORDER BY ".$list_by." ".$list_order." LIMIT ".$start.",".$category;
$page_result = MySQLQuery("SELECT * FROM links WHERE cat_id=$cat_id",$QueryError_Email,$QueryError_Browser);
$previous_page=$start - $category;
$next_page=$start + $category;
$numrows=mysql_num_rows($page_result);
if(($start > 0) || ($numrows > ($start + $category))){echo "<p class=\"bodysm\">";}
if($start > 0){echo "[ <a href=\"fav.php?ax=list&l=list_by&cat_id=$cat_id&start=$previous_page\">< < Previous</a> ]\n";}
if($numrows > ($start + $category)){echo "[ <a href=\"fav.php?ax=list&l=list_by&cat_id=$cat_id&start=$next_page\">Next > ></a> ]\n";}
if(($start > 0) || ($numrows > ($start + $category))){echo "</p>";}
}
$result = MySQLQuery($sql_rqst,$QueryError_Email,$QueryError_Browser);
while($row = mysql_fetch_array($result))
{
$id=$row["id"];
$name=$row["name"];
$clicks=$row["clicks"];
$approved=$row["approved"];
$url=$row["url"];
$dsc=$row["dsc"];
$date_added=$row["date_added"];
$year = substr($date_added, 0, 4);
$month = substr($date_added, 5, 2);
$day = substr($date_added, 8, 2);
$date_added=date($display_format,mktime("00","00","00",$month,$day,$year));
$image=$row["image"];
$rating=$row["rating"];
$rates=$row["rates"];
if($image_enabled=="yes" && $image)
{
$image="<img src=\"$image\" align=\"right\">";
}
else
{
$image="";
}
?>
<p class="bodymd2"><?php echo $image; ?><a href="<?php echo fav.php ?>?ax=out&id=<?php echo $id ?>"><?php echo $name ?></a>
<br /><span class="bodysm2">[ Ajouté le: <?php echo $date_added ?> | Nombre de cliques: <?php echo $clicks ?> | Note: <?php echo $rate_stat ?> | <a href="#" onclick="blocking('<?php echo $id ?>');return false;">Noté le site</a> | <a href="fav.php?ax=deadlink&id=<?php echo $id ?>">Signaler un lien mort</a> ]</span>
<br /><?php echo $dsc ?>
<br /><div id="<?php echo $id ?>"><form action="<?php echo fav.php ?>?ax=addrate&id=<?php echo $id ?>&cat_id=<?php echo $formcat_id; ?>&l=<?php echo $list_type; ?>" method="post" id="form<?php echo $id; ?>" onsubmit="return validate_rate<?php echo $id; ?>();"><span class="bodysm">Rate This Website</span> <select name="rating" class="bodysm"><option>- choose --</option><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option></select> <input type="submit" name="submit" value="Rate <?php echo $name ?>" class="bodysm" /></div></form>
</p>
<?php
}
if($_GET["l"]!="date_added" && $_GET["l"]!="clicks")
{
if(($start > 0) || ($numrows > ($start + $category))){echo "<p class=\"bodysm\">";}
if($start > 0){echo "[ <a href=\"fav.php?ax=list&l=list_by&cat_id=$cat_id&start=$previous_page\">< < Previous</a> ]\n";}
if($numrows > ($start + $category)){echo "[ <a href=\"fav.php?ax=list&l=list_by&cat_id=$cat_id&start=$next_page\">Next > ></a> ]\n";}
if(($start > 0) || ($numrows > ($start + $category))){echo "</p>";}
} Si quelqu'un a une idées, merci d'avance
