Re: Select news based on dates

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi!
You can use "order by date" and such method:
<code>
$result = mysql_query(blablabla);
$date = "foo";
while($news = mysql_fetch_array($result)){
    if ($date==$news["date"]){
        echo "new date";
    }
    echo $news["text"];
    $date = $news["date"];
}


Monday, May 17, 2004, 3:50:04 PM, T. wrote:

THG> Hello,

THG> I would like to display my news like this:

THG> *10.04.2004.*
THG> - news 1
THG> - news 2
THG> - news 3
THG> *14.04.2004.*
THG> - news 4
THG> *15.04.2004.*
THG> - news 5
THG> ...

THG> I'm thinking of some while loop but I'm not sure that it will work nor I 
THG> know how to create that query.

THG> TNX



-- 
Best regards,
Mikhail U. Petrov
mailto:mikhail@xxxxxxxx

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux