"Daniel Clark" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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!!!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
