1) { $pgno = $pgno; } $sql = "SELECT count(id) as totrecs FROM tbl_jeyadurgha_audiocats ORDER BY disorder ASC"; $result = @mysql_query($sql); if (mysql_affected_rows()!=0) { while ($row = mysql_fetch_array($result)) { $totrecs = $row['totrecs']; } } $totpages1 = $totrecs/10; if ($totrecs == ($totpages1*10) || $totrecs < ($totpages1*10) ) { $totpages = $totpages1; } else if ($totrecs > ($totpages1*10) ) { $totpages = $totpages1 + 1; } ?>
<? echo $row['title']; ?>
.
.
 
 
($totpages1*10) ) { $totpages = $totpages1 + 1; } if ($pgno == 1) { $sql = "SELECT *, title_" . $fieldsurfix . " AS title FROM tbl_jeyadurgha_audiocats ORDER BY disorder ASC LIMIT 0, 15"; } else if ($pgno > 1 ) { $sql = "SELECT * FROM tbl_jeyadurgha_audiocats ORDER BY disorder ASC LIMIT " . ($pgno-1) * 15 . ", 15"; } $result = @mysql_query($sql); if (mysql_affected_rows()!=0) { ?>
<? echo $row['title']; ?>
 
<? echo $row['title']; ?>