Thanks to Hugh and DL Neil for their answers. I got it working now with your help. Makes me feel dumb now!
-- Andrés > > In your SQL request, sort by date. When printing the output, > keep track of the previous date - only print the date if it > changes. Something like > > $conn = mysql_pconnect($host, $usr, $pwd); > mysql_select_db("mydb"); > $sql = "SELECT id,date,time,title,body FROM mytable ORDER > BY date DESC"; > $res = mysql_query($sql); > > $date = "previous date"; > while($row = mysql_fetch_array($res)) { > if ($date != $row["date"]) { > $date = $row["date"]; > echo "<br>$date"; > } > > echo "<p>".$row["time"]." ".$row["title"]; > echo "<br>".$row["body"]; > } > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]