Re: Re: repeating data from one column until data from another column changes
| From: | Daniel Clark | Date: | Tue, 04 May 2004 22:02:28 +0000 |
| Subject: | Re: Re: repeating data from one column until data from another column changes | ||
| References: | 1 2 3 4 5 6 7 8 9 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-185364@lists.php.net to get a copy of this message | ||
Are you getting any output?
> <?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)); ?>