While + doložený medzizáznam v PHP

<?php
$poradie = 1;
while ($poradie <= 3) {
        echo $poradie++."<br>\n";
}

<?php
$poradie = 1;
$vyber = mysql_query("SELECT * FROM moja_tabulka");
while ($roadok = $mysql_fetch_object($vyber)) {
        echo $poradie++.".";
        echo "<h3>{$vyber->meno}<h3>";
        echo "<img src=\"image.php?id={$vyber->ID}.jpg\">";
}

select
meno,
id,
case when datediff(dd, some_time, getdate()) < 1 then 'today'
when datediff(dd, some_time, getdate()) >= 1 AND datediff(dd, some_time, getdate()) < 7 then 'this week'
when datediff(dd, some_time, getdate()) >= 7 AND datediff(dd, some_time, getdate()) < 30 then 'this month' else 'old' end as time_flag
order by
some_time desc

$poradie = 1;
$flag = ""
$vyber = mysql_query("sem pride kvera");
while ($vyber = $mysql_fetch_object($vyber)) {
    if($flag != $vyber->time_flag)
    {
        echo $vyber->time_flag;
    }
        $flag = $vyber->time_flag;
        echo $poradie++.".";
        echo "<h3>{$vyber->meno}<h3>";
        echo "<img src=\"image.php?id={$vyber->ID}.jpg\">";
}