If you have no may articles then there will be no records returned.
Just change the . date('m') to the actualy month you want if not the
current month.
----- Original Message -----
From: "msa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 04, 2004 3:59 PM
Subject: Re: [PHP] Re: repeating data from one column until data from
another column changes
> ----- 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?
> >
> > Torsten
>
>
> the 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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
