= CURDATE() or closing_date='0000-00-00') ORDER BY TRIM( LEADING 'a ' FROM TRIM( LEADING 'an ' FROM TRIM( LEADING 'the ' FROM LOWER( title ) ) ) )"; $result = mysql_query($sql,$link); while (list($title,$uri) = mysql_fetch_array($result)) { $title = ucwords(strtolower($title)); if (preg_match('/^The\s*?(.*)/',$title,$match)) { $title = ltrim($match[1]) . ", The"; } $broadway_shows[$title] = $uri; } // Get links for off-broadway shows $sql = "SELECT title, virtual_url FROM shows WHERE broadway='N' and published='Y' and placeholder='N' and (closing_date >= CURDATE() or closing_date='0000-00-00') ORDER BY TRIM( LEADING 'a ' FROM TRIM( LEADING 'an ' FROM TRIM( LEADING 'the ' FROM LOWER( title ) ) ) )"; $result = mysql_query($sql,$link); while (list($title,$uri) = mysql_fetch_array($result)) { $title = ucwords(strtolower($title)); if (preg_match('/^The\s*?(.*)/',$title,$match)) { $title = $match[1] . ", The"; } $off_broadway_shows[$title] = $uri; } // Get list of upcoming shows $sql = "SELECT title, virtual_url, opening_date, broadway FROM shows WHERE placeholder='Y' AND published='Y' ORDER BY opening_date"; $result = mysql_query($sql,$link); while ($row = mysql_fetch_array($result)) { $month_year = strtoupper(strftime('%b %Y',strtotime($row['opening_date']))); $day = strftime('%e',strtotime($row['opening_date'])); $show[$day] = $row['title']; if ($row['broadway'] == 'Y') { $url = '/shows/' . $row['virtual_url']; } else { $url = '/shows/off-broadway/' . $row['virtual_url']; } if ($upcoming[$month_year][$day]) { array_push($upcoming[$month_year][$day],array('title' => $row['title'], 'url' => $url)); } else { $upcoming[$month_year][$day] = array(); array_push($upcoming[$month_year][$day],array('title' => $row['title'], 'url' => $url)); } } // Get quick reviews $sql = "SELECT reviews.rating as rating, newspapers.short_title as newspaper, shows.image as image, shows.id as id FROM reviews, shows, newspapers WHERE shows.image IS NOT NULL AND shows.broadway='Y' AND shows.published='Y' AND shows.placeholder='N' AND newspapers.id=reviews.newspaper_id AND reviews.show_id=shows.id AND (shows.closing_date >= CURDATE() or shows.closing_date='0000-00-00') ORDER BY TRIM( LEADING 'a ' FROM TRIM( LEADING 'an ' FROM TRIM( LEADING 'the ' FROM LOWER( shows.title ) ) ) ), reviews.display_order"; $result = mysql_query($sql,$link); $numrows = mysql_num_rows($result); while ($row = mysql_fetch_array($result)) { if (!array_key_exists($row['id'],$quick_reviews)) { $quick_reviews[$row['id']] = array(); } array_push($quick_reviews[$row['id']], array('newspaper' => $row['newspaper'], 'rating' => $row['rating'], 'image' => $row['image'])); } $rating_image['positive'] = 'indexbenhappy.jpg'; $rating_image['mixed'] = 'indexbenmixed.jpg'; $rating_image['negative'] = 'indexbensad.jpg'; $rating_image['unavailable'] = 'notavailable.jpg'; ?>
BROADWAY REVIEWSforeach ($broadway_shows as $title => $uri): ?> echo $title; ?>endforeach ?> OFF-BROADWAY REVIEWSforeach ($off_broadway_shows as $title => $uri): ?> echo $title; ?>endforeach ?> |
QUICK REVIEW GUIDE Refer to the chart below for a quick overview of reviews for current Broadway Shows! foreach ($quick_reviews as $quick_review): ?> if (sizeof($quick_review) >= 5): ?>
|
COMING UP:
$nextshow = current($upcoming); $nextshowinfo = current($nextshow); $nextshowtitle = current($nextshowinfo); echo $nextshowtitle['title']; ?> Sign up and you could win FREE TICKETS! UPCOMING SHOWS:
foreach ($upcoming as $month_year => $shows) {
echo "$month_year ![]() |
||||||||||||
HOME I ABOUT I REVIEW GUIDE I TELL A FRIEND I CONTACT US I FAQ I © echo strftime('%Y',time()); ?> DIDHELIKEIT.COM DidHeLikeIt.com is the top Broadway resource for reviews of Broadway plays and musicals. We provide show reviews from The New York Times,
|
||||||||||||||