Coloring rows in table

[ds_john]

I have an event listing page. It contains the events for a year. Now "ALL THE ROWS IN THE TABLE" are displayed in alternate colors of grey and white. How do I get to color the current or the next available event row (if there is no event today) "YELLOW". I have stored the event dates in the format "YYYY-MM-DD" which can be compared with the server date and colored. I dont know exactly how it can be done.

I tried using:

$row_color = ($dateToday == $dateThisRow?"yellow"🙁$row_color == "white"?"grey":"white"))

but it showed all the grey rows as green. Also I could use the same logic but, then wont it just color the row ONLY if the event date corresponds with todays date? What happens if there is no event today - no row is coloured :eek: . But then I would like to color the next available event from today. (if no event today highlight next availabe event dated after todays date).

Given below is the coding i used.

$today = date("Y-m-d");// today's date
$i = 0; //color initializing

while ($row = mysql_fetch_array($retid)) {

$begindate= $row["BEGIN_DATE"];

$bgcolor = ($i++ & 1) ? 'lightgrey' : 'white';

print "<tr bgcolor='$bgcolor'>\n";
}

Is it possible to alternate color the future event rows also 😃 .
Past events (Alt. grey & white)
Present event or next available event (yellow)
Future events (Alt. dark grey & white)

May be I'm asking for too much :o . Any way can someone help me out?

[herve]

Hi

may be I've missed something, but why
don't simply test the individual dates
and choose color accordingly ?

let's say that :

$date_event is the date of an event
$current_date ... well guess it 🙂

--- 8< ---

$grey=0; // For having the very first row as white
$first_event_after=1;

in the main loop (event by event)

if ($date_event < $current_date)
{
if ($grey)
{
$color="#D0D0D0"; // Grey row
$grey=0;
}
else
{
$color="#FFFFFF"; // White row
$grey=1;
}
}
else
{
if ($first_event_after)
{
$color="#FFFF00"; // Yellow row
$first_event_after=0;
}
else
{
if ($grey)
{
$color="#D0D0D0"; // Grey row
$grey=0;
}
else
{
$color="#FFFFFF"; // White row
$grey=1;
}
}
}
--- 8< ---

That's suppose to give you :

Past events (Alt. grey & white)
Present event or next available event (yellow)
Future events (Alt. dark grey & white)

regards,
Hervé.

[herve]

Ouch !

Without tabulations the source code is not
awfully readable I'm afraid 🙂

Just Copy & Paste it in an editor to make
things more clear !