query("select * from shifts");
echo "
";
$buffer=$result;
while($row=$buffer->fetchRow()){
echo "
shift: $row[sh_id]";
}
echo "
";
$buffer=$result;
while($row=$buffer->fetchRow()){
echo "
shift: $row[sh_id]";
}
echo "
";
$buffer=$result;
while($row=$buffer->fetchRow()){
echo "
shift: $row[sh_id]";
}
?>
problem - only the first loop prints anything. I can't seem to be able to loop those result rows more than once. I have played with reset(), but not had any joy.