I am creating an event listing. The listing will show a weeks worth of events sorted by day and time. for brevity I’ve include only 3 days.
My code…below will pull information based on today, today+1 and today+2. This is how I distinguish days.
If one of my dates does not have any information, I would for it not to show.
For example:
Monday January 16, 2012
6:00a.m. - Breakfast
9:00a.m. - Meeting
12:00 p.m. - Lunch
Tuesday, January 17, 2012
(no events)
Wednesday, January 18, 2012
6:00a.m. - Breakfast
9:00a.m. - Meeting
12:00 p.m. - Lunch
I would like to skip (not show anything for ) any dates that don’t have a listing.
Here’s the Code:
[php]
//TODAY
$today2 = date(‘l, F j, Y’);//php to format date
$today_rehearsals = mysql_query(" SELECT Id, date, time, title, campus, room, ministry, category
FROM events
LEFT JOIN dates on events.dateId=dates.dateId
LEFT JOIN time ON events.timeId=time.timeId
LEFT JOIN campus ON events.campusId=campus.campusId
LEFT JOIN rooms ON events.roomId=rooms.roomId
LEFT JOIN ministries on events.ministryId=ministries.ministryId
LEFT JOIN category on events.categoryId=category.categoryId
WHERE ministry=‘music’ AND date=’$today’ OR category=‘music’ AND date=’$today’
ORDER By date, time")
//////DAY ONE
$day1= mktime(0,0,0, date(“m”), date(“d”)+1, date(“Y”)); //php to get current date and add 1 day
$day_1 = date(“l, F j, Y”, $day1); //php to format date
$day1_rehearsal = mysql_query(“SELECT Id, date, time, title, campus, room, ministry, category FROM events
LEFT JOIN dates ON events.dateId=dates.dateId
LEFT JOIN time ON events.timeId=time.timeId
LEFT JOIN campus ON events.campusId=campus.campusId
LEFT JOIN rooms ON events.roomId=rooms.roomId
LEFT JOIN ministries ON events.ministryId=ministries.ministryId
LEFT JOIN category ON events.categoryId=category.categoryId
WHERE ministry=‘music’ AND date=CURDATE()+1 OR category=‘music’ AND date=CURDATE()+1
ORDER BY time” )
or die(mysql_error());
/////DAY 2
$day2= mktime(0,0,0, date(“m”), date(“d”)+2, date(“Y”)); //php to get current date and add 1 day
$day_2 = date(“l, F j, Y”, $day2); //php to format date
$day2_rehearsal = mysql_query(“SELECT Id, date, time, title, campus, room, ministry, category FROM events
LEFT JOIN dates ON events.dateId=dates.dateId
LEFT JOIN time ON events.timeId=time.timeId
LEFT JOIN campus ON events.campusId=campus.campusId
LEFT JOIN rooms ON events.roomId=rooms.roomId
LEFT JOIN ministries ON events.ministryId=ministries.ministryId
LEFT JOIN category ON events.categoryId=category.categoryId
WHERE ministry=‘music’ AND date=CURDATE()+2 OR category=‘music’ AND date=CURDATE()+2
ORDER By time”)
or die(mysql_error());
////TODAY
echo “$today2”//renders Today’s date
while($row = mysql_fetch_array( $today_rehearsals )){
$time=date_create($row['time']);//grab time for db
$for_time=date_format($time, 'g:i a');//format time for viewing on page
echo "$for_time"
echo $row['title']
echo $row['campus'] . " " . $row['room'] . '</div>';
}
////day1
echo “$day_1”//renders Today’s date
while($row = mysql_fetch_array( $day1_rehearsal )){
$time=date_create($row['time']);//grab time for db
$for_time=date_format($time, 'g:i a');//format time for viewing on page
echo "$for_time"
echo $row['title']
echo $row['campus'] . " " . $row['room'] . '</div>';
}
////day2
echo “$day_2”//renders Today’s date
while($row = mysql_fetch_array( $day2_rehearsal )){
$time=date_create($row['time']);//grab time for db
$for_time=date_format($time, 'g:i a');//format time for viewing on page
echo "$for_time"
echo $row['title']
echo $row['campus'] . " " . $row['room'] . '</div>';
}
[/php]