news display

From: Date: Wed, 12 Sep 2001 10:04:07 +0000
Subject: news display
Groups: php.general 
Request: Send a blank email to php-general+get-67029@lists.php.net to get a copy of this message
Hey all! I have a slight problem I was hoping you could help me with. I'm writing a little news script for my site, and well here is the scenario: I have 2 tables in a mysql database, one holds author information (name, email, password, etc.) The other table holds the news that they submit (news, date, time, headline, etc.) Now I am trying to display the news on a page, ordered of course by date (or id in this case) and well i'm using the code below. <?php $db = mysql_pconnect("localhost"); mysql_select_db("news",$db); $result1 = mysql_query("SELECT * FROM news,authors ORDER BY id DESC",$db); while($myrow=mysql_fetch_array($result1)) { echo "<table cellpadding=0 cellspacing=0><tr><td><img src=images/r13.gif></td><td background=images/r14.gif width=100%><p><font size=2 face=verdana color=white><strong>" . $myrow["headline"] . "</strong></FONT> <font size=1 face=verdana color=white><br>Posted by <A HREF=mailto:" . $myrow["email"] . ">" . $myrow["author"] . "</A> at " . $myrow["time"] . $myrow["$tod"] . "</FONT></td><td><img src=images/r15.gif></td></tr></table><br><FONT COLOR=white SIZE=2 FACE=verdana>" . $myrow["news"] . "<br><br>"; } ?> So the results would look something like: $Headline Posted by $author at $time $news and it would of course just repeat, for however many entries there is. Now the problem: If I enter 4 news posts a day, I want to show 1 date above all the news posts. (Instead of 1 date next to each news post) Any idea how I can do this (In easy to understand lingo/code please)? Thanks! Nate

« previous php.general (#67029) next »