[RESOLVED] Mysql Paging, Division Problem

[exponder]

I'm doing a very simple private "paging" system. When I divide Numrows, with my rows per page variable, I keep getting 0. Meh, Been working on it all day and eyes have gone crosseyed. Could anyone lend a moment to gaze over my code?

<?
$rpp = 100;
if(!$page || $page == 1){
	$start = 0;
}else{
	$offset = $page-1;
	$start = ($offset * $rpp);
}
$dbQuery = "select * FROM highalch ORDER BY id ASC LIMIT $start,100"; 
$result = mysql_query($dbQuery) or die("Couldn't get file list");
$numrows = $row['numrows'];
   if($page > 1) {
   $prevpage = $page -1;
}
  $currentend = $start +25;
  $maxPage = ceil($numrows/$rpp);
if(mysql_num_rows(mysql_query("SELECT * FROM highalch ORDER BY ID ASC LIMIT $currentend"))) {
   if(!page) {
      $nextpage = 2;
       } else {
        $nextpage = $page +1;
  }
}
?>
<table width="90%" cellpadding="1" cellspacing="1" bgcolor="#B8C7CE">
<Tr>
<td align="center" align="top" bgcolor="#F2F2F2" class="TIT">
<?
if ($prevpage || $nextpage) {
	if($prevpage){
         echo ("( <a href=\"?page=".$prevpage."\">Previous Page</a> ) - "); 
 }else{ 
         echo ("");
  }
if($nextpage){
          echo ("( <a href=\"?page=".$nextpage."\">Next Page</a> )");
 }else{ 
         echo ("");
 }
}
   echo ("( - <a href=\"?page=$maxPage\">[Last Page]</a> )");
?>

I get a link of "file.php?page=0"

Any suggestions would be great.

[Weedpacket]

$dbQuery = "select * FROM highalch ORDER BY id ASC LIMIT $start,100"; 
$result = mysql_query($dbQuery) or die("Couldn't get file list");
$numrows = $row['numrows']; 

Something missing from here perhaps?

$rowcount_query = "Select count(*) from highalch";
$rowcount_result = mysql_query($rowcount_query);
$numrows = mysql_result($rowcount_result, 0);

is what I'm guessing you intended.

Do your development with error_reporting set to E_ALL and PHP will warn you about mistakes like this (specifically, it would have told you about an uninitialized array index 'numrows').

[exponder]

sigh, thanks man.

Feel like a tard, but got it.

Thanks for the tips btw!