the code again...
at top of document (with strange WHERE clause removed......
<?php require_once('Connections/jpike.php'); ?>
<?php
mysql_select_db($database_jpike, $jpike);
$query_rsENews = "SELECT * FROM NewsArchive ORDER BY date DESC";
$rsENews = mysql_query($query_rsENews, $jpike) or die(mysql_error());
$row_rsENews = mysql_fetch_assoc($rsENews);
$totalRows_rsENews = mysql_num_rows($rsENews);
?>
in body of document:
<table class="eMenu" cellspacing="0">
<tr>
<td> <?php do { ?>
<a class="eMenu"><?php echo $row_rsENewsTitles['title']; ?></a>
<?php } while ($row_rsENewsTitles =
mysql_fetch_assoc($rsENewsTitles)); ?>
</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>
<?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)); ?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
