$now=date("Y-m-d");
$sql="select * from exhibitions where start_date='".$now."'";
$ID=mysql_query($sql, $conn);
$i=1;
while(list($selected_id, $start_date, $end_date, $selected_title, $description)=mysql_fetch_row($ID)) {
$temp=explode("-", $start_date);
$s_date=date("F d, Y", mktime(0,0,0, $temp[1],$temp[2],$temp[0]));
$temp=explode("-", $end_date);
$e_date=date("F d, Y", mktime(0,0,0, $temp[1],$temp[2],$temp[0]));
print "
".$selected_title."";
if($s_date!="0000-00-00" && $e_date!="0000-00-00") {
if($s_date==$e_date) {
print "
".$s_date."";
} else {
print "
".$s_date." - ".$e_date."";
}
}
print "
".preg_replace("/\n\r/", "
",ltrim((string)$description))."
";
$i++;
} // End while(list($selected_id, $start_date, $end_date, $selected_title, $description)=mysql_fetch_row($ID))
$sql="select * from exhibitions where start_date<='".$now."' and end_date>'".$now."' order by start_date asc";
$ID=mysql_query($sql, $conn);
$i=1;
while(list($selected_id, $start_date, $end_date, $selected_title, $description)=mysql_fetch_row($ID)) {
$temp=explode("-", $start_date);
$s_date=date("F d, Y", mktime(0,0,0, $temp[1],$temp[2],$temp[0]));
$temp=explode("-", $end_date);
$e_date=date("F d, Y", mktime(0,0,0, $temp[1],$temp[2],$temp[0]));
print "
".$selected_title."";
if($s_date!="0000-00-00" && $e_date!="0000-00-00") {
if($s_date==$e_date) {
print "
".$s_date."";
} else {
print "
".$s_date." - ".$e_date."";
}
}
print "
".preg_replace("/\n\r/", "
",ltrim((string)$description))."
";
$i++;
} // End while(list($selected_id, $start_date, $end_date, $selected_title, $description)=mysql_fetch_row($ID))
?>