if within mysql_fetch_array

Anon

I am querying records from a mysql db. I want to make a check against a date field and echo the results depending on if a new date is processed or if the previous date is again in the records.

Simple as below:
January 20, 2002 5 miles
6 miles
January 21, 2002 8 miles
10 miles
January 22, 2002 12 miles
January 23, 2002 13 miles

Below is how I am "attempting this"! Appreciate the feedback!!!!

<?php

$query = "SELECT *, DATE_FORMAT(rundate, '%W, %M %d') as fdate from log";

$result = mysql_query($query);

for ($i=0; $i<8; $i++)
{
$row = mysql_fetch_array($result);
echo ("<tr>");

if ($fdate ! $fdate)
    {
//DATE OF RUN TD AND VALUE

echo ("<TD BGCOLOR=#999999 ALIGN=CENTER VALIGN=TOP ROWSPAN=2><FONT FACE=trebuchet, verdana, arial, helvetica, sans-serif SIZE=2>");
echo ($row[fdate]);

    echo ("</TD>");
    }
else
{

echo ("<TD BGCOLOR=#999999 ALIGN=CENTER VALIGN=TOP><FONT FACE=trebuchet, verdana, arial, helvetica, sans-serif SIZE=2>");
echo ($row[workout_type]);
}

nevrar

in your select statement, go (at the end of it), "...from log ORDER by rundate"

That will put your dates in order..

Then, while next row {
if ($row[fdate]==$tmpdate) just print miles
else {
$tmpdate = $row[fdate];
print date and miles;
}

Anon

Thanks for the input...one question. At what point are you assigning a value to $tmpdate, a little confused on that.

Thanks.

Anon

Additional question...

how do you process the while (next row)...a little confused on the syntax to that as well. Newby to PHP...Thanks.

nevrar

$tmpdate is the value of the previous date. If the current date = the previous date then you are repeating the date, so don't show it. (the dates are in order remember...)

rather than doing a for loop, you can do a loop depending on the number of rows in the result set:

$query = "SELECT *, DATE_FORMAT(rundate, '%W, %M %d') as fdate from log order by rundate";
$result = mysql_query($query);

echo '<table border="0">';
while ($row = mysql_fetch_array($result)😉 {
echo "<tr>";

//print the date if it's new
$currentdate = $row[date];
if ($currentdate!=$previousdate) {
//then it's a new date
echo '<td bgcolor="#999999" align="center" valign="top" rowspan="2">'.$currentdate.'</td>';
$previousdate = $currentdate;
}
//else don't print the date

//print the workout type

echo '<TD BGCOLOR="#999999" ALIGN="CENTER" VALIGN="TOP">'.$row[workout_type].'</td>';
echo "</tr>";
} //end of while loop
echo "</table>";

Anon

EXCELLENT! Thanks for the insight, much appreciated!!