Ik heb bv. 10 members in mijn database
Hoe kan ik laten zien dat er 10 members in de database zitten?
653 views
Met <? mysql_num_rows(); ?> 
Waar moet de tabelnaam dan staan?
<?php
$sql="select * from members";
$res=mysql_query($sql);
$row=mysql_fetch_row($res);
$count=mysql_num_rows($res); //aantal members
//=================================
//Of zoiets lukt ook
$sql="select count(*) from members";
$res=mysql_query($sql);
$row=mysql_fetch_row($res); // $row[0] is aantal members
?>
$sql="select * from members";
$res=mysql_query($sql);
$row=mysql_fetch_row($res);
$count=mysql_num_rows($res); //aantal members
//=================================
//Of zoiets lukt ook
$sql="select count(*) from members";
$res=mysql_query($sql);
$row=mysql_fetch_row($res); // $row[0] is aantal members
?>