Kod · PHP
<?php
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `dayb` = '" . date('j', time()) . "' AND `monthb` = '" . date('n', time()) . "' AND `preg` = '1'"), 0);
if ($total) {
echo'<div class="menu">';
echo' <b>Tug`ilgan kuningiz bilan tabriklaymiz!</b><br>';
$req = mysql_query("SELECT * FROM `users` WHERE `dayb` = '" . date('j', time()) . "' AND `monthb` = '" . date('n', time()) . "' AND `preg` = '1' LIMIT $start, $kmess");
$hour=date('Y');
while ($res = mysql_fetch_assoc($req)) {
$yoshi = $hour - $res['yearofbirth'];
echo ''.($i > 1 ? ', ' : '').' <a href="users/profile.php?user='.$res['id'].'">'.$res['name'].'</a> <span style="color: gray;">('.$yoshi.')</span>';
++$i;
}
echo'</div> ';
}
?>37 soniyadan keyin yozdi:
ishlamayapdi
