user_stat.php
909 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
<?
$ls_sql="select COUNT(*) from zlo_users";
$result = mysql_query($ls_sql);
$row = mysql_fetch_row($result);
$users = $row[0]; // âñåãî çàïèñåé
?>
<table cellpadding="5" cellspacing="5" border="0">
<tr>
<td>
Âñåãî ïîêóïàòåëåé:
</td>
<td>
<? echo $users; ?>
</td>
</tr>
<tr>
<td colspan="2">
Èç íèõ:
</td>
</tr>
<?
$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(*)"]));
?>
<tr>
<td>
<?
group_name($group, &$group_name);
echo $group_name.":";
?>
</td>
<td>
<?
echo $count."<br>";
?>
</td>
</tr>
<?
}
?>
<tr>
<td>
</td>
</tr>
</table>