Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 9


I received this error message a while ago. The funny thing is, my php scripts were working perfectly well earlier, until I increased the records from 20 to 400.

Snippets of my script:

$query="SELECT * FROM ssipass WHERE given=''";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();


$i=0;
while ($i < $num) {

$id=mysql_result($result,$i,"id");
$ssiuser=mysql_result($result,$i,"ssiuser");
$ssipass=mysql_result($result,$i,"ssipass");
$given=mysql_result($result,$i,"given");
?>

Any help is appreciated.

L8R

jason