Query By Weekend
Posted: Mon Feb 09, 2009 3:32 pm
i mistakenly put this in the database section.
Will the code below work? I want to, based on the date, show events for the current weekend. My database has a date feild and day feild.
Will the code below work? I want to, based on the date, show events for the current weekend. My database has a date feild and day feild.
Code: Select all
function show_weekend() {
$date = CURDATE();
$day_of_the_week = DAYOFMONTH($date);
if $day_of_week = '1'{
$date_range_1 = $date - 2;
$q = "SELECT `tb_events`.`event_title`, `tb_events`.`date`, `tb_events`.`info`\n"
. "FROM `tb_events`\n"
. "WHERE (date BETWEEN $date AND $date_range_1) AND WHERE `tb_events`.`event_title` = 1, 6, 7\n"
. "ORDER BY `tb_events`.`date` ASC\n"
. " LIMIT 0, 30 ";
$result = $mysqli->query($q) or die($mysqli_error($mysqli));
if ($result) {
while($row = $result->fetch_object()) {
$tile = $row->event_title;
$date = $row->date;
$info = $row->info;
print '<h3>'.$title.'</h3>
<p>'.$date.'</p>
<p>'.$info.'</p>
';
print "\n";
}
}
else if ($day_of_week = '2') {
$date_range_1 = $date + 4;
$date_range_2 = $date + 6;
$q = "SELECT `tb_events`.`event_title`, `tb_events`.`date`, `tb_events`.`info`\n"
. "FROM `tb_events`\n"
. "WHERE (date BETWEEN $date_range_1 AND $date_range_2)\n"
. "ORDER BY `tb_events`.`date` ASC\n"
. " LIMIT 0, 30 ";
while($row = $result->fetch_object()) {
$tile = $row->event_title;
$date = $row->date;
$info = $row->info;
print '<h3>'.$title.'</h3>
<p>'.$date.'</p>
<p>'.$info.'</p>
';
print "\n";
}
}
}