debug=true; $SQLg = "SELECT * FROM plant A LEFT JOIN city B ON (A.id_city=B.id_city) ORDER BY A.id_plant ASC "; $RSg =$db->Execute($SQLg); if ($RSg->fields["id_plant"] != "") { $total_jumlah_record = $RSg->RecordCount(); $total_jumlah_page = ceil(($total_jumlah_record)/$conf["front_page"]); $teks_parameter = ""; if ($page != 0 ) { if ($page > $total_jumlah_page) $page=$total_jumlah_page; $pagination = pagination($page, $total_jumlah_page, $teks_parameter); $i=0; $SQL = "SELECT * FROM plant A LEFT JOIN city B ON (A.id_city=B.id_city) ORDER BY A.id_plant LIMIT " . (($conf["front_page"] * $page ) - $conf["front_page"]) . ",".$conf["front_page"]; $RSg =$db->Execute($SQL); while (!$RSg->EOF) { if(empty($RSg->fields["thumbnail"])) $image="nophoto.png"; else $image=$RSg->fields["thumbnail"]; echo '

'.$RSg->fields["title"].'

'.$RSg->fields[plant_name].'
'; $i++; if ($i==3){$i=0; echo "
"; } $RSg->MoveNext(); } echo "

"; echo "
Page :  
" .$pagination["halaman_first"] . $pagination["halaman_next"] . $pagination["halaman_content"] . $pagination["halaman_prev"] .$pagination["halaman_last"]."
"; } } ?>