the code angain....
| From: | msa | Date: | Wed, 05 May 2004 00:16:38 +0000 |
| Subject: | the code angain.... | ||
| References: | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-185379@lists.php.net to get a copy of this message | ||
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)); ?>