[Resolved] Losing first records

[madd_mike]

I lose the first record of every new day that displays the data and I can't figure out why? Can some of you wonderful folks help me out? Here is my code:

$query = "SELECT artist,venue,timeofevent,dateofevent,date_format(dateofevent,'%M %d, %Y') as dateofevent FROM newevents where dateofevent >= curdate() and timeofevent >curtime()";
$result = mysql_query($query);

//used to color the cells
$numofrows = mysql_num_rows($result);
//used to color the cells

echo "<TABLE BORDER=\"0\">\n";
echo "<TR bgcolor=\"green\"><TD>DATE</TD><TD>ARTIST</TD><TD>VENUE</TD></TR>\n";

while($row = mysql_fetch_array($result))

// echo "You have $numrows user(s) in the database";
for($i = 0; $i < $numofrows; $i++) {
$row = mysql_fetch_array($result); //get a row from our result set
if($i % 2) { //this means if there is a remainder
echo "<TR bgcolor=\"lightgreen\">\n";
} else { //if there isn't a remainder we will do the else
echo "<TR bgcolor=\"white\">\n";
}
echo "<TD>".$row['dateofevent']."</TD><TD>".$row['artist']."</TD><TD>".$row['venue']."</TD>\n";
echo "</TR>\n";
}
//now let's close the table and be done with it
echo "</TABLE>\n";

mysql_close(); // Close the database

[tsinka]

Hi,

you use mysql_fetch_array two times (while loop and for loop).
You don't need the for loop, just use the while loop.

Put a $i=0 somewhere in front of the while loop and a $i++ inside the while loop.

Thomas

[madd_mike]

I figured it to be pointer problem and I nderstand what you are saying, nbut I don't know PHP that well and can't figure it out...can you show me where to put the statements?

Thanks

[Sxooter]

Easy, either do the while() method, or the for() method. Don't do both.

[tsinka]

$i=0;
while($row = mysql_fetch_array($result)) {
  $dateofevent = $row['dateofevent'];
  $artist = $row['artist'];
  $venue = $row['venue'];  

  // echo "You have $numrows user(s) in the database"; 
  if($i % 2) { 
    $color = "lightgreen";
  } else { 
    $color="white";
  }

  echo <<< EOHTML
<tr bgcolor="$color">
  <td>$dateofevent</td>
  <td>$artist</td>
  <td>$venue</td>
</tr>

EOHTML;

  $i++;
} 

Make sure that there are no trailing whitespaces at the end of the echo <<< EOHTML line.

Thomas

[madd_mike]

<?php

// Connect to the database
$db = mysql_connect(*************);
mysql_select_db ("***************");

echo ' Today is ',date('F j, Y'), ' --- You accessed this page from IP Address ',$REMOTE_ADDR;

// Ask the database for the information from the table

$query = "SELECT artist,venue,dateofevent,date_format(dateofevent,'%M %d, %Y') as dateofevent FROM newevents where dateofevent >= curdate()";
$result = mysql_query($query);

//used to color the cells
$numofrows = mysql_num_rows($result);
//used to color the cells

echo "<TABLE BORDER=\"0\">\n";
echo "<TR bgcolor=\"green\"><TD>DATE</TD><TD>ARTIST</TD><TD>VENUE</TD></TR>\n";

$i=0;
while($row = mysql_fetch_array($result)) {
$dateofevent = $row['dateofevent'];
$artist = $row['artist'];
$venue = $row['venue'];

// echo "You have $numrows user(s) in the database";
if($i % 2) {

$color = "lightgreen";
} else {

$color="white";
}

echo <<< EOHTML
<tr bgcolor="$color">
<td>$dateofevent</td>
<td>$artist</td>
<td>$venue</td>
</tr>

EOHTML;

$i++;
}

mysql_close(); // Close the database

?>
HERE IS THE ERROR I GET:

Parse error: parse error, unexpected $ in /home/clevel04/public_html/eventswithdate8.php on line 87
LINE 87 IS THE echo <<< EOHTML statement line...

Thanks

[tsinka]

Hi,

make sure that there are no trailing whitespaces at the end of both lines
echo <<< EOHTML
and
EOHTML;

or replace the heredoc syntax by a standard string syntax.

Thomas

[madd_mike]

Who would have thought white spaces...it now works...checkt out...Events

Do you think theres a way to make every other date alternate colors? That way each even day would be green and each odd day would be white? dateofevent is stored as yyyy-mm-dd and is a date field with a template of YYYY-MM-DD?

THANKS FOR YOUR HELP...DO YOU DO FREELANCE PROGRAMMING?

MIKE

[tsinka]

Hi,

you should change the SELECT query since it contains dateofevent twice (dateofevent,date_format(...) AS dateofevent)

Change date_format(...) to something like

date_format(...) AS eventdate and use this to display the formatted date in the table.

Use dateofevent itself to set the color, like

<?PHP
...
$dateofevent = $row['eventdate'];
$thedate = $row['dateofevent'];

// if dateofevent is YYYY-MM-DD we simply
// remove the - characters to get a number
// (or use substr instead of str_replace)
if (str_replace("-","",$thedate) % 2) {
...
?>

Thomas

[madd_mike]

Thank you for all of your help, it works great...I wish I knew half as much as you guys!!!