if ($qs=="") {$qs=0;}
$result = mysqli_query($connection, "SELECT COUNT(*) from customers where tumuli = '$gekozen' AND checked='1'") or die(mysqli_error());
$count = mysqli_result($result,0,0);
echo "";
echo "Achternaam | tv | ";
echo "Voornaam | ";
echo "Geboren | ";
echo "Gestorven | ";
$result = mysqli_query($connection, "SELECT * from customers where tumuli = '$gekozen' AND checked='1' order by $sorder LIMIT $qs,$range") or die(mysqli_error());
// $numresults=mysqli_num_rows($result); Geeft resultaten van een rij.
while ($row = mysqli_fetch_array($result))
{ if ($bgcolor=='#c5dd8f') {$bgcolor='#9eb1c4';} else {$bgcolor='#c5dd8f';}
echo "".$row["lastname"]." | ";
echo $row["betweenname"]." | ".$row["firstname"]." | ";
echo $row["born"]." | ".$row["died"]." | ";
}
mysqli_free_result($result);
echo " ";
if ($count>$range){echo " ";
}
?>
|