Сирожиддин
JohnCMS scriptida ma'lumotlarni bosh sahifaga chiqarish haqida.
Kod · PHP21 qator
echo '<div class="phdr">So\'ngi a\'zolar</div>';

$oxirgi = mysql_query("SELECT * FROM `users` ORDER BY `datereg` DESC LIMIT 2");

while ($uka = mysql_fetch_assoc($oxirgi)) {

    echo '<div class="menu">';

    $yosh = date("Y") - $uka['yearofbirth'];

    if ($uka['sex'])

        echo functions::image(($uka['sex'] == 'm' ? 'm' : 'w') . ($uka['datereg'] > time() - 86400 ? '_new' : '') . '.png', array('class' => 'icon-inline'));

        echo '<a href="/users/profile.php?user='.$uka['id'].'"> '.$uka['name'].'</a>';

        echo '<br/>'.$yosh.' yosh, '.$uka['live'];

    echo '</div>';

}

Bunda johncmsni off scriptidagi baza bilan ishlaydi yani shaxarga shaxar yozsa chiqadi tug'ilgan yilini yozsa yoshi chiqadi aks holda 2017 turadi!