";
for ($i=0; $i < $kolom; $i++) {
echo "| ";
if ($data = mysql_fetch_row ($select))
$cid=$data[0];
$catname=$data[1];
$select2 = mysql_query ("SELECT * FROM link where idcategory='$cid'");
$jumlah=mysql_num_rows ($select2);
echo "$catname ($jumlah)";
echo " | ";
}
echo "";
}
?>
Show All Link Exchange Total : $total";
$jmlhalaman = ceil( $total / $limit);
// ambil data sejumlah besarnya pesan per halaman
$page = $_GET[page];
if(!isset($page))
{
$page = 1;
}
$offset = ($page - 1) * $limit;
$query = "select * from link where display='yes' order by lid LIMIT $offset,$limit";
$hasil = mysql_query($query);
if ($page == 1) {
$start = 0;
$end = $limit;
} elseif ($page <= $jmlhalaman && $page > 1) {
$start = ($page - 1) * $limit;
$end = $start + $limit;
} else {
$page = 1;
}
while($data = mysql_fetch_array($hasil))
{
echo "". $start + 1 .". ";
$lid=$data[0];
$url=$data[1];
$mylink_url=$data[2];
$title=$data[3];
$description=$data[4];
$contact_name=$data[5];
$contact_email=$data[6];
$postdate=$data[8];
$cid=$data[10];
$hasilnya= mysql_query ("SELECT * FROM catlink where cid='$cid'");
while ($datanya = mysql_fetch_row($hasilnya))
$catname=$datanya[1];
echo "
$title";
echo "$description [ $postdate ] $url
";
echo "
Category : $catname";
$start ++;
}
if ($page >= 1 && $page <= $jmlhalaman && $total > $limit) {
if ($page != 1) {
echo ("
« Sebelumnya ");
}
for($i=1;$i<=$jmlhalaman;$i++)
{
if ($_GET[page] == $i)
{
echo "$i | ";
}
else
{
echo "
$i | ";
}
}
if ($page <= ($jmlhalaman - 1)) {
echo ("
Selanjutnya »");
}
}
?>