0 AND $bk_top=1 AND BK_PRICE<>'0.00' AND IS_CLONE=0 "; //$total_records = mysql_fetch_array(mysql_db_query($dbname,$SQL)); //$total_records = $total_records[num]; $total_records = mysql_db_query($dbname,$SQL); $total_records=mysql_result($total_records,0,"num"); $SQL = "SELECT HTM_TITLE,SUB_HEAD FROM bk_topic WHERE LIST_NAME='".$_GET['bk_top']."'"; //select the home section $title = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query $titleCount = mysql_numrows($title); ?>
Results per page:

0 AND $bk_top=1 AND BK_PRICE<>'0.00' AND IS_CLONE=0 ORDER BY TITLE"; //select the home section if($itemsPerPage!="NA"){ $SQL=$SQL." LIMIT $start, $itemsPerPage;"; //select the home section } $results = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query $RecCount = mysql_numrows($results); ?>
<< "; $thePage=$_GET['page']; }else{ echo " "; $thePage=1; } if($total_records>$itemsPerPage){ for($i=1;$i < ceil($total_records/$itemsPerPage)+1;$i++){ if ($_GET['page']<>$i){ if($_GET['page']=="" && $i==1){ echo $i." "; }else{ echo "".$i." "; } }else{ echo $i." "; } } if($_GET['page']<>ceil($total_records/$itemsPerPage)){ echo ">> "; }else{ echo " "; } } ?>
">
_sm.jpg">

">
" style="font-size:.9em;">

$
<< "; $thePage=$_GET['page']; }else{ echo " "; $thePage=1; } if($total_records>$itemsPerPage){ for($i=1;$i < ceil($total_records/$itemsPerPage)+1;$i++){ if ($_GET['page']<>$i){ if($_GET['page']=="" && $i==1){ echo $i." "; }else{ echo "".$i." "; } }else{ echo $i." "; } } if($_GET['page']<>ceil($total_records/$itemsPerPage)){ echo ">> "; }else{ echo " "; } } ?>