help with an fields in a table with dates

[madd_mike]

Okay, here's my issue. I open my database, do my select from events...then I do my fetch and all my records post with $row[name]...my question is this, I have a field called dateofevent that contains the date YYYY-MM-DD. I want to only find the records that have an even DD and print those in a different color than all the rest. I know how to do the coloring part but how do I do an IF statement on dateofevent after I do the query? I guess I'm not sure of the syntax...I don't want to select the dates with my select from table...can anyone guide me in the right direction?
Thanks

[j_miguel_y]

Hey,
According to what you said, you have a field dateofevent, and you are using a mysql_fetch_array.

The problem/question is dateofevent is probably stored as a string/date in the database.

If that is the case, $row[dateofevent] will contain that specifc date after every loop. So within the mysql_fetch_array() loop you also have to include.

SELECT EXTRACT(MONTH FROM '$row[dateofevent]');
and obtain the month since it turns into an integer and put it into some variale called $EvenOdd. then make if statements

if ($EvenOdd%2 == 0){
.
.
.

                               }

else{
.
.

  }