Aantal members in db showen
Hoe kan ik laten zien dat er 10 members in de database zitten?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
<?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
?>