Got error 28 from table handler

[osusano]

help i got an error

Got error 28 from table handler
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/deposit.php on line 64

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/deposit.php on line 66
Got error 28 from table handler
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/deposit.php on line 101

i tried to use this command

/usr/local/mysql/bin/myisamchk -r deposit

but still got the same problem

can any 1 here help me pls.

[tekky]

need to see the script thats doing the query and anything pertinent to that section.... right now it looks like you arent doing the query at all or you are doing a query thats returning nothing maybe...

[osusano]

<?
   include "connect.php"; 
   if ($rstart == ''){$rstart=0;}
   if ($pgptr == ''){$pgptr=1;}
   $sizeLimit = 15;
   $sqlQry = mysql_query("select * from deposit,customer,product where (deposit.custId=customer.custId) and (deposit.pCode=product.prodId) and (deposit.status='') order by (deposit.date) desc");
   print mysql_error();
   $numRows = mysql_num_rows($sqlQry);
   $totalRows = mysql_num_rows($sqlQry);
   $totalPages = intval($totalRows / $sizeLimit);
   $excess = $totalRows % $sizeLimit;

   if ($excess > 0){ $totalPages = $totalPages + 1; }
   $i = 0;
   if ($totalPages > 10){
      $i = $i + ($pgptr - 1);
   } else { $i = 0; }
      $trstart = $rstart;
      $pages = "";
      if ($totalPages > 10){
          if (($i != 0)) { $rstart = $rstart - $sizeLimit; $pages = $pages."<a href='deposit.php?pgptr=$i&rstart=$rstart'>[&lt&lt Previous]</a>&nbsp;&nbsp; "; }
      }
      if ($totalPages > 10) { $value = (10+($pgptr-1)); } else {$value = $totalPages;}
      while ($i < $value){
      $rstart = $sizeLimit * $i;
      $i++;
         if ($i == $pgptr){
            $pages = $pages."<b>$i</b> ";
         } else {
            $pages = $pages."<a href='deposit.php?pgptr=$i&rstart=$rstart'>$i</a> ";
         }
      }
      if ($totalPages > 10){
         $i = $i + 1;
         $rstart = $rstart + $sizeLimit;
         $pages = $pages."&nbsp;<a href='deposit.php?pgptr=$i&rstart=$rstart'>[Next &gt&gt]</a>";
      }
      $rstart = $trstart;
      $fRow = (($pgptr-1) * $sizeLimit) + 1;
      $i = $fRow - 1;

  $sqlQry = mysql_query("select * from deposit,customer,product where (deposit.custId=customer.custId) and (deposit.pCode=product.prodId) and (deposit.status='') order by (deposit.date) desc limit $rstart,$sizeLimit");
  print mysql_error();
  $numRows = mysql_num_rows($sqlQry);
  if ($numRows >0){ 
     while ($hRow = mysql_fetch_array($sqlQry)) { 
        $depId = $hRow["depId"];
        $issueId = $hRow["issueId"];
        $date = $hRow["date"];
        $custName	= $hRow["custName"];
        $prodName	= $hRow["productName"];
        $qty = $hRow["dQty"];
        $amount = $hRow["amt"];
        $amtDep = $hRow["amtDep"];
        $i++;
?>
<tr bgcolor=#E9E9E9 height=25>
   <td align=center><a href="editDeposit.php?nav=2&issueId=<? print $issueId; ?>"><? print $issueId; ?></a></td>
   <td align=center><? print $date; ?></td>
   <td><? print $custName; ?></td>
   <td><? print $prodName; ?></td>
   <td align=right><? print $qty; ?>&nbsp;</td>
   <td align=right><? print number_format($amount,2); ?>&nbsp;</td>
   <td align=right><? print number_format($amtDep,2); ?>&nbsp;</td>
</tr>
<?
      }
   }
?>

[osusano]

b4 the script is working and afterwards it just give me an error which is stated above..

thank you in advance for those people willing to help

[tekky]

I assume those lines are the query statements in this code?
and I assume that you are meaning to query multiple tables?

[Weedpacket]

Since the first error message that appears (and the one that you used as the title of this thread) came from MySQL via the call to mysql_error(), I thought it prudent to go the the MySQL documentation and find out what it says about "Got error 28 from table handler". Not a huge amount, because apparently those error numbers are system dependent. The closest was a link that describes how to get a description of what an error number means.

Maybe that will supply some information.