|
<?php
$title = 'Знакомства';
require '../system/function.php';
require '../system/header.php';
$us = mysql_result(mysql_query("SELECT COUNT(*) FROM `users`"),0);
$m = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `sex` <= '1' "),0);
$w = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `sex` >= '2' "),0);
echo '<div class="title">'.$title.'</div><div class="podmenu"> <a href="/user/all"> Все анкеты <span class="count">'.$us.'</span></a></div>';
echo '<div class="podmenu"> <a href="man"> Парни <span class="count">'.$m.'</span></a></div>';
echo '<div class="podmenu"> <a href="woman"> Девушки <span class="count">'.$w.'</span></a></div>';
echo '<div class="title"> 3-ка новичков</div>';
$q = mysql_query("select * from `users` ORDER BY `id` desc LIMIT 3;");
$post = mysql_fetch_array(mysql_query("select `login` from `users` where `id` = '$id[0]';"));
while ($post = mysql_fetch_array($q))
{
echo '<div class="podmenu">';
echo "".nick($post['id'])." ";
echo "</div>";
}
require_once('../system/footer.php');
?>