----- Original Message ----- > > 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);
>
> The above line is already fetching the first row from the result. Is this
> what you want at this point of the script? If not put // in front to out
> ocmment it.
>
> > $totalRows_rsENews = mysql_num_rows($rsENews);
>
> Please print out $totalRows_rsENews and post the value.
>
> Have you checked if you have articles with a May date?
>
> Torstenthe above code is what dreamweaver writes when I create a connection to the table in the database... there 192 records total and no may records as of yet. I do not understand why that is pertinent...? there are 10 articles listed for april....but every month varies. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
