Показать сообщение отдельно

  #17  
Старый 30.03.2009, 19:54
mss-s
Новичок
Регистрация: 02.03.2009
Сообщений: 18
С нами: 9049302

Репутация: 4
По умолчанию

вот вот как идеот подщот статьстьки может переделать и этова

Код:
<tr>
    <th width="121" align="left" scope="row">&nbsp;Участников  -
        <?
    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">&nbsp;Новых заказов -</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">&nbsp;Подтв. заказов -</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">&nbsp;Уровень 0 -</th>
    <th align="right" scope="row">
      <?=$ur0;?>
    </th>
  </tr>
  <tr>
    <th align="left" scope="row">&nbsp;Уровень 1 -</th>
    <th align="right" scope="row">
      <?=$ur1;?>
    </th>
  </tr>
  <tr>
    <th align="left" scope="row">&nbsp;Уровень 2 -</th>
    <th align="right" scope="row">
      <?=$ur2;?>
    </th>
  </tr>
  <tr>
    <th align="left" scope="row">&nbsp;Уровень 3 -</th>
    <th align="right" scope="row">
      <?=$ur3;?>
    </th>
  </tr>
  <tr>
    <th align="left" scope="row">&nbsp;Уровень 4 -</th>
    <th align="right" scope="row">
      <?=$ur4;?>
    </th>
  </tr>
  <tr>
    <th align="left" scope="row">&nbsp;Уровень 5 -</th>
    <th align="right" scope="row">
      <?=$ur5;?>
    </th>
  </tr>
  <tr>
    <th align="left" scope="row">&nbsp;Уровень 6 -</th>
    <th align="right" scope="row">
      <?=$ur6;?>
    </th>
  </tr>
  <tr>
    <th align="left" scope="row">&nbsp;Уровень 7 -</th>
    <th align="right" scope="row">
      <?=$ur7;?>
    </th>
  </tr>
  <tr>
    <th align="left" scope="row">&nbsp;Уровень 8 -</th>
    <th align="right" scope="row">
      <?=$ur8;?>
    </th>
  </tr>
 
Ответить с цитированием