=CURDATE() order by eventDate, eventID asc LIMIT 2";
$eventResult = mysql_query($eventQuery);
//If there are events
if (mysql_num_rows($eventResult) > 0) {
echo "
";
echo "
";
}
//if there are no more events in the calendar this will print an empty paragraph
else {
echo "
";
}
//Code for generating the Upcoming Kids and Family Events section of the sidebar. If there are upcoming
//kids events, then the block is generated with no more than 1 of the upcoming events. If there
//are no events upcoming, it should print a simple
//Querying the DB for the next upcoming kids events. It must
//also occur on or after the current date
$kidEventQuery = "SELECT eventID, dayofmonth(eventDate) as eventDay, monthname(eventDate) as monthName, eventDate, eventTime, title FROM events WHERE eventDate>=CURDATE() and eventCategory=5 LIMIT 1";
$kidEventResult = mysql_query($kidEventQuery);
//If there are events
if (mysql_num_rows($kidEventResult) > 0) {
echo "
";
echo "
";
}
//if there are no more events in the calendar this will print an empty paragraph
else {
echo "
";
}
?>
Find out about the stars of our collections. Each month we spotlight one of the rarely seen Museum treasures.
Never miss a Museum event or exhibit again. Sign up for our Museum Update. It's FREE!
Presented in three iterations of 20-30 Navajo textiles each, Navajo Weaving: Diamonds, Dreams, Landscapes will showcase the breadth and depth of the Museum's Joe Ben Wheat Southwestern Textile Collection, considered to be one of the world's best collections of Navajo textiles.
Museum News
Here are a couple of things that are going on in the Museum. For a list of our recent news items, please see our Museum News page.
There are no news items in our system at this time.";
}
else
{
//Here I'm saying that if more than 3 news stories were returned, then set
//the $num_news variable to be 3. That way when we loop through the
//newsResult, we will only get 3.
if ($num_news > 3)
{
$num_news = 3;
}
echo "
";
?>
