Re: displaing news

Thanks Tom, I'm still a newbie at this stuff though, so can you (or anyone) look this over and tell me what I did wrong... <?php //Connect to db $db = mysql_pconnect("localhost"); mysql_select_db("news",$db); $result1 = mysql_query("SELECT * FROM news,authors ORDER BY id DESC",$db); $is_first=true; while($myrow=mysql_fetch_array($result1)) { if($is_first) { $lastdate=$myrow["date"]; $thisdate=$myrow["date"]; $is_first=false; } if($thisdate==$lastdate) { echo "text here" . $myrow["headline"] . "Posted by <A HREF=mailto:" . $myrow["email"] . ">" . $myrow["author"] . "</a> at " . $myrow["time"] . $myrow["$tod"] . "<br><br>" . $myrow["news"] . "<br><br>"; } else { echo "<h2>" . $myrow["date"] . "text here" . $myrow["headline"] . "Posted by <A HREF=mailto:" . $myrow["email"] . ">" . $myrow["author"] . "</a> at " . $myrow["time"] . $myrow["$tod"] . "<br><br>" . $myrow["news"] . "<br><br>"; } $lastdate=$thisdate; } ?> I wasn't sure how to assign the $lastdate and $thisdate variables. ----- Original Message ----- From: "Tom Carter" <subs@roundcorners.com> To: <nate@1feehosting.com>; <php-general@lists.php.net> Sent: Wednesday, September 12, 2001 9:37 AM Subject: Re: [PHP] displaing news > rough outline of what you would need to do..... > > this is pseudocode.. I'm too tired to write correct php :) > > $is_first=true; > whlie(get next result entry) { > if($is_first) { > $last-date=date of this entry; > $this-date=date of this entry; > $is_first=false; > } > > if($this-date==$last-date) { > just put the article after the current one > } else { > start a new section, displaying date etc > } > > $last-date=$this-date; > } > > ----- Original Message ----- > From: <nate@1feehosting.com> > To: <php-general@lists.php.net> > Sent: Wednesday, September 12, 2001 5:24 PM > Subject: [PHP] displaing news > > > Hey all! > > I have a slight problem I was hoping you could help me with. I wrote earlier > but no response (so one last try). I'm writing a little news script for my > site, and well here is the scenario: > > The SHORT: > > I have news,headline,author,date,time,etc. all in a table in a mysql db, > that I use mysql_fetch_array to pull out of the db and display on a page. It > shows everything fine, but I was wondering, if there is more than one news > entry per day, how can I display 1 date above the news entries for that day. > (Instead of a seperate date for each news entry). > > > The LONG: > > 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 > > >