Re: Select news based on dates
| From: | Daniel Clark | Date: | Mon, 17 May 2004 18:43:43 +0000 |
| Subject: | Re: Select news based on dates | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34458@lists.php.net to get a copy of this message | ||
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> ...