Просмотр поста

KanzaS (10.11.2010/18:36)
$reqm = mysql_query("SELECT `id`, `name`, `sex`, `age`, `live`, `lastdate`, `datereg`, `rights`, `ip`, `browser`, `rights` FROM `users` WHERE `preg` = 1 AND `sex` = 'm' ORDER BY `bals` DESC LIMIT 1");

Пробуй так

$reqm = mysql_query("SELECT `id`, `name`, `avatar`, `sex`, `age`, `live`, `lastdate`, `datereg`, `rights`, `ip`, `browser`, `rights` FROM `users` WHERE `preg` = 1 AND `sex` = 'm' ORDER BY `bals` DESC LIMIT 1");
while ($resm = mysql_fetch_assoc($reqm)) {
echo '<div class="list1">Лучший парень:
';
echo show_user($resm, 1, (($rights > 1) ? 2 : 0)) . '</div>';
}
$req = mysql_query("SELECT `id`, `name`, `avatar`, `sex`, `age`, `live`, `lastdate`, `datereg`, `rights`, `ip`, `browser`, `rights` FROM `users` WHERE `preg` = 1 AND `sex` = 'zh' ORDER BY `bals` DESC LIMIT 1");
while ($res = mysql_fetch_assoc($req)) {
echo '<div class="list1">Лучшая девушка:
';
echo show_user($res, 1, (($rights > 1) ? 2 : 0)) . '</div>';
}