Re[2]: [PHP-DB] Select news based on dates
| From: | Mikhail U. Petrov | Date: | Tue, 18 May 2004 11:56:31 +0000 |
| Subject: | Re[2]: [PHP-DB] Select news based on dates | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34459@lists.php.net to get a copy of this message | ||
Hi!
"text" is of no importance.
I work only with "date".
If it's useful, nobody can prohibit that for you.
Monday, May 17, 2004, 10:43:43 PM, Daniel wrote:
DC> ORDER BY date, text ?
>> 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> ...
--
Best regards,
Mikhail U. Petrov
mailto:mikhail@begun.ru