querying an array

[jsherwin]

I have a mySQL table that contains a number of calender events. I am able to query the table and select out only those events that fall during the current week

<?php
$sql = "select * from events where week(event_date) = week(current_date) order by event_date";
$result = mysql_query($sql);
?>

I would like to be able to take these events and further select from them based on day of week so that I can have a table that looks something like . . .

Monday
-event1
-event2

Tuesday
-event3

Wednesday
-event4

etc.

I think this can be done with if statements, but do not know how to apply them to the first returned array. Any help?

JCS

[barand]

try

<?php 
$sql = "select * from events where week(event_date) = week(current_date) order by event_date"; 
$result = mysql_query($sql); 
$lastday="";
while ($row = mysql_fetch_array($result)) {
  $day = date ("l",strtotime($row["event_date"]));
  if ($day!=$lastday) {
    echo "$day<br>";
  }
  echo $row["event"]."<br>";
  $lastday = $day;
}
?> 

hth