Re: Re: repeating data from one column until data from another column changes

"Daniel Clark" <dclark@nwlink.com> wrote in message news:51606.65.203.232.102.1083706708.squirrel@webmail.pacifier.com... > Are you looping through the record set? i thought I was, but it isn't working!! here is the code with all of the latest suggestions..... start code at top of document: <?php require_once('Connections/jpike.php'); ?> <?php mysql_select_db($database_jpike, $jpike); $query_rsENews = 'SELECT * FROM NewsArchive WHERE YEAR(date) = ' . date('Y') . ' AND MONTH(date) = ' . date('m') . ' ORDER BY sort DESC'; $rsENews = mysql_query($query_rsENews, $jpike) or die(mysql_error()); $row_rsENews = mysql_fetch_assoc($rsENews); $totalRows_rsENews = mysql_num_rows($rsENews); ?> end top code start code in body of document: <table class="eMenu" cellspacing="0"> <tr> //this is where I would like to list the titles of the articles for the current month <td><?php do { ?> <a class="eMenu"><?php echo $row_rsENews['title']; ?></a> <?php } while ($row_rsENews = mysql_fetch_assoc($rsENews)); ?> </td> </tr> </table> <h3>E-News <?php $theYear = substr($row_rsLatestDate['date'], 0, 4); $theMonth = substr($row_rsLatestDate['date'], 5, 2); $theDay = substr($row_rsLatestDate['date'], 8, 2); $timestamp = mktime(0, 0, 0, $theMonth, $theDay, $theYear); echo date('F j, Y', $timestamp); ?></h3> //this is where i want the list to be title and article for the current month <?php do { ?> <h4><a name="<?php echo $row_rsENews['sort']; ?>"></a><br> <?php echo $row_rsENews['title'];?></h4> <p><?php echo $row_rsENews['description']; ?></p> <p><a href="#top">top</a><br> </p> <?php } while ($row_rsENews = mysql_fetch_assoc($rsENews)); ?> end code I didn't hand write much of this....dreamweaver writes a lot of it behind the scenes.....i'm not much of a code writer, just get into small needs here and there...REALLY appreciate all of you trying to help me!!!