RE: [PHP-DB] Re: Retrieving data woes

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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > >