= 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 recent reviews $sql = "SELECT reviews.review as review, reviews.critic as critic, reviews.published_date as date, reviews.rating as rating, shows.title as title, 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 and (shows.closing_date >= CURDATE() or shows.closing_date='0000-00-00') 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); if ($pos[$limit]) { $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 ?> REVIEW ARCHIVEClick here to view past reviewsTESTIMONIALS"Did He Like It keeps my finger on the pulse of what’s hot and what’s not on Broadway. It makes me a better Producer." "DidHeLikeIt.com tells me all I need to know after an opening; the site of cartoon Ben on a fence or puking says it all!!" "Did He Like It is a must read for anyone with an interest in Broadway theater...this is by far the best site on the web as it relates to Broadway reviews...I have it saved on my favorites!!!!" |
ABOUT DIDHELIKEIT.COM![]() HIS LATEST REVIEW
HIS MOST RECENT REVIEWS
endif ?> endforeach ?> |
COMING UP:
$nextshow = current($upcoming); $nextshowinfo = current($nextshow); $nextshowtitle = current($nextshowinfo); echo $nextshowtitle['title']; ?>
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 ADVERTISE 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, Book of Mormon Tickets, Spiderman Tickets and Josh Groban Tour information. | |||||||||||||||