$ls_sql="select COUNT(*) from zlo_users";
$result = mysql_query($ls_sql);
$row = mysql_fetch_row($result);
$users = $row[0]; // âñåãî çàïèñåé
?>
Âñåãî ïîêóïàòåëåé:
|
echo $users; ?>
|
Èç íèõ:
|
$ls_sql="SELECT zlo_users.group, COUNT(*) FROM zlo_users GROUP BY zlo_users.group";
$result = mysql_query($ls_sql);
$num_results = mysql_num_rows($result);
for ($i = 0; $i < $num_results; $i++)
{
$row = mysql_fetch_array($result);
$group = htmlspecialchars(stripcslashes($row["group"]));
$count = htmlspecialchars(stripcslashes($row["COUNT(*)"]));
?>
group_name($group, &$group_name);
echo $group_name.":";
?>
|
echo $count." ";
?>
|
}
?>
|