= 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 links for closed broadway shows $sql = "SELECT title, virtual_url FROM shows WHERE broadway='Y' and published='Y' and (closing_date < CURDATE() and 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"; } $closed_broadway_shows[$title] = $uri; } // Get links for closed off-broadway shows $sql = "SELECT title, virtual_url FROM shows WHERE broadway='N' and published='Y' and (closing_date < CURDATE() and 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"; } $closed_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 recent reviews $sql = "SELECT reviews.review as review, reviews.critic as critic, reviews.published_date as date, reviews.rating as rating, shows.image as image, shows.virtual_url as virtual_url, shows.broadway as broadway FROM reviews, shows, newspapers WHERE reviews.newspaper_id=newspapers.id and newspapers.title='New York Times' and shows.id=reviews.show_id ORDER BY reviews.published_date DESC LIMIT 7"; $result = mysql_query($sql,$link); while ($row = mysql_fetch_array($result)) { array_push($recent_reviews,$row); } $latest_review = array_shift($recent_reviews); function limit_text($text, $limit) { if (strlen($text) > $limit) { $words = str_word_count($text, 2); $pos = array_keys($words); $text = substr($text, 0, $pos[$limit]) . '...'; } return $text; } $rating_image['positive'] = 'indexbenhappy.jpg'; $rating_image['mixed'] = 'indexbenmixed.jpg'; $rating_image['negative'] = 'indexbensad.jpg'; ?>
BROADWAY REVIEWSforeach ($broadway_shows as $title => $uri): ?> echo $title; ?>endforeach ?> OFF-BROADWAY REVIEWSforeach ($off_broadway_shows as $title => $uri): ?> echo $title; ?>endforeach ?> |
BROADWAY REVIEW ARCHIVEChoose a link below to see Ben Brantley and New York Times reviews for past Broadway and Off-Broadway shows!
|
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, Shop Broadway Tickets for the hottest Broadway events including hard-to-find Wicked Tickets, Jersey Boys Tickets, Lion King Tickets and Spiderman Tickets.
|
||||