
30.03.2009, 19:54
|
|
Новичок
Регистрация: 02.03.2009
Сообщений: 18
С нами:
9049302
Репутация:
4
|
|
вот вот как идеот подщот статьстьки может переделать и этова
Код:
<tr>
<th width="121" align="left" scope="row"> Участников -
<?
require ("connectdb.inc.php");
$sql=mysql_query("select*from users");
$num=mysql_num_rows($sql);
$sql1=mysql_query("select*from orders");
$num_nord=mysql_num_rows($sql1);
$sql2=mysql_query("select*from orders2");
$old_ord=mysql_num_rows($sql2);
$sql3 = mysql_query("SELECT * FROM `users` where rang='0'");
$ur0=mysql_num_rows($sql3);
$sql4 = mysql_query("SELECT * FROM `users` where rang='1'");
$ur1=mysql_num_rows($sql4);
$sql5 = mysql_query("SELECT * FROM `users` where rang='2'");
$ur2=mysql_num_rows($sql5);
$sql6 = mysql_query("SELECT * FROM `users` where rang='3'");
$ur3=mysql_num_rows($sql6);
$sql7 = mysql_query("SELECT * FROM `users` where rang='4'");
$ur4=mysql_num_rows($sql7);
$sql8 = mysql_query("SELECT * FROM `users` where rang='5'");
$ur5=mysql_num_rows($sql8);
$sql9 = mysql_query("SELECT * FROM `users` where rang='6'");
$ur6=mysql_num_rows($sql9);
$sql10 = mysql_query("SELECT * FROM `users` where rang='7'");
$ur7=mysql_num_rows($sql10);
$sql11 = mysql_query("SELECT * FROM `users` where rang='8'");
$ur8=mysql_num_rows($sql11);
$sql12=mysql_query("select*from users where date between subdate(now(), interval 0 day) and now()");
$row00=mysql_num_rows($sql12);
?></th>
<th width="43" align="right" scope="row">
<?=$num;?>
</th>
</tr>
<tr>
<th colspan="2" align="right" scope="row"></th>
</tr>
<tr>
<th colspan="2" align="right" scope="row"></th>
</tr>
<tr>
<th align="left" scope="row"> Новых заказов -</th>
<th align="right" scope="row">
<?=$num_nord;?>
</th>
</tr>
<tr>
<th colspan="2" align="right" scope="row"></th>
</tr>
<tr>
<th align="left" scope="row"> Подтв. заказов -</th>
<th align="right" scope="row">
<?=$old_ord;?>
</th>
</tr>
<tr>
<th colspan="2" scope="row"></th>
</tr>
<tr>
<th colspan="2" scope="row"></th>
</tr>
<tr>
<th align="left" scope="row"> Уровень 0 -</th>
<th align="right" scope="row">
<?=$ur0;?>
</th>
</tr>
<tr>
<th align="left" scope="row"> Уровень 1 -</th>
<th align="right" scope="row">
<?=$ur1;?>
</th>
</tr>
<tr>
<th align="left" scope="row"> Уровень 2 -</th>
<th align="right" scope="row">
<?=$ur2;?>
</th>
</tr>
<tr>
<th align="left" scope="row"> Уровень 3 -</th>
<th align="right" scope="row">
<?=$ur3;?>
</th>
</tr>
<tr>
<th align="left" scope="row"> Уровень 4 -</th>
<th align="right" scope="row">
<?=$ur4;?>
</th>
</tr>
<tr>
<th align="left" scope="row"> Уровень 5 -</th>
<th align="right" scope="row">
<?=$ur5;?>
</th>
</tr>
<tr>
<th align="left" scope="row"> Уровень 6 -</th>
<th align="right" scope="row">
<?=$ur6;?>
</th>
</tr>
<tr>
<th align="left" scope="row"> Уровень 7 -</th>
<th align="right" scope="row">
<?=$ur7;?>
</th>
</tr>
<tr>
<th align="left" scope="row"> Уровень 8 -</th>
<th align="right" scope="row">
<?=$ur8;?>
</th>
</tr>
|
|
|