From: "T. H. Grejc" <php@xxxxxxxxxxxxxxx>
> I would like to display my news like this:
>
> *10.04.2004.*
> - news 1
> - news 2
> - news 3
> *14.04.2004.*
> - news 4
> *15.04.2004.*
> - news 5
> ...
>
> I'm thinking of some while loop but I'm not sure that it will work nor I
> know how to create that query.
SELECT your data with the date and only display the date if it changes.
$query = "SELECT * FROM table ORDER BY datecolumn ASC";
$result = mysql_query($query) or die(mysql_error());
$prevdate = '';
while($row = mysql_fetch_assoc($result))
{
if($row['datecolumn'] != $prevdate)
{
echo '*' . $row['datecolumn'] . '*<br />';
$prevdate = $row['datecolumn'];
}
echo '- ' . $row['news'] . '<br />';
}
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
