Re: 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.