"Andres Sulleiro" <[EMAIL PROTECTED]> wrote in message
002001c18193$eacb4450$[EMAIL PROTECTED]">news:002001c18193$eacb4450$[EMAIL PROTECTED]...
> I have a db table that has these columns:
> id, date, time, title, body
>
> some of the rows can have the same "date" and want to output the data
> according to "date". Like so:
>
> dateA
> timeA1, titleA1
> bodyA1
>
> timeA2, titleA2
> bodyA2
>
> dateB
> timeB1, titleB1
> BodyB1
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]
