That's exactly it! I don't know why I didn't think about that. For anyone else reading this, I added
$field = mysql_fetch_array($dbArray); above the line that reads $yeartitle = $years["year"]; And now it works! "Richard Davey" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello Nicole, > > Thursday, February 19, 2004, 6:28:13 PM, you wrote: > > N> And so on, always putting the right years and the right number of histories > N> below the year, but always listing the first history and nothing else. My > N> loop works if I don't have the while loop in there with the subheadings ... > > In looking quickly at the code, I can't see a chance for the $field > value to ever be updated. You call it once (in the first while > statement) and populate the field array with the SQL results, you then > move into the 2nd while loop which handles the years. But once in that > loop you don't fill the $field array with any new data, so it's using > the same data over and over again for every year. I believe, although > I've not looked at it for very long, it's simply that the while loops > are nested in such a way that the field values never get a chance to > re-populate themselves. > > -- > Best regards, > Richard Davey > http://www.phpcommunity.org/wiki/296.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php