From: "T. H. Grejc" <[EMAIL PROTECTED]>

> 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

Reply via email to