) will print the starting HTML along with whatever you want in the title ?> , ) will print a banner with an image and alternate text ?>
$bcparentname, 'link' => $bcparentlink); html_breadcrumbs($bclocation, $bcpage); } else { html_breadcrumbs('NONE'); } /******************* END BREADCRUMB TRAIL ******************/ ?>
 
  '; } ?> array( 'table' => 'reviewstheater', 'SQL' => 'SELECT id, datetime, author, title, venue, review, images FROM reviewstheater WHERE id='.$_REQUEST['review'] ), 2 => array( 'table' => 'reviewsmovies', 'SQL' => 'SELECT id, datetime, author, title, review, images FROM reviewsmovies WHERE id='.$_REQUEST['review'] ), 3 => array( 'table' => 'musicreviews', 'SQL' => 'SELECT id, datetime, author, artist, album, review, tracklist, images, labname, laburl FROM musicreviews WHERE id='.$_REQUEST['review'] ), 4 => array( 'table' => 'dvdreviews', 'SQL' => 'SELECT id, datetime, title, reviewer, body FROM reviewsdvd WHERE id='.$_REQUEST['review'] ), ); if($db = db_connect()) { if(isset($_REQUEST['rtype'])) { if(isset($rtypes[$_REQUEST['rtype']])) { $rtable = $rtypes[$_REQUEST['rtype']]['table']; $SQL = $rtypes[$_REQUEST['rtype']]['SQL']; } else { print'
';print_r($rtypes);print'
'; die('bad review type'); } if(!$result = mysql_query($SQL, $db)) { die('Query failed '.mysql_error()); } else { if($_REQUEST['rtype'] == 4) { while($set = mysql_fetch_assoc($result)) { list($reviewdate, $reviewtime) = split(' ', $set['datetime']); echo ' '; } } else { while($set = mysql_fetch_assoc($result)) { $reviewimages = split(',', $set['images']); list($reviewdate, $reviewtime) = split(' ', $set['datetime']); if(isset($set['venue'])) { $venue = ' - '.$set['venue']; } else { $venue = ''; } echo ' '; } } } } else { $SQL = 'SELECT id, datetime, author, artist, album, review, tracklist, images, labname, laburl FROM musicreviews WHERE id='.$_REQUEST['review']; if(!$result = mysql_query($SQL, $db)) { die('Query failed '.mysql_error()); } else { while($set = mysql_fetch_assoc($result)) { $reviewimages = split(',', $set['images']); list($reviewdate, $reviewtime) = split(' ', $set['datetime']); echo ' '; if(isset($set['labname'])){ echo ' '; } echo ' '; } } } } else { die('unable to connect to db'); } db_close($db); } else { include($DOCROOT.'/includes/reviews_summaries_new.inc'); } /*******************************************/ ?>
Reviews

If you read a book, see a movie, listen to a new album or discover a new band, we want to read about it! Click here and let us know what you found.
 
DISCLAIMER: Reviews are the opinions of the individual reviewer and do not necessarily represent the views of DarkTwinCities.com.
 
'.$set['title'].'
[return to reviews]
Review by '.$set['reviewer'].'
 
'.$set['body'].'
 
'.$set['title'].' '.$venue.'
[return to reviews]
Review by '.$set['author'].'
 
'.$set['review'].'
 
'.$set['artist'].' - '.$set['album'].' [return to reviews]
Label: '.$set['labname'].'
Review by '.$set['author'].'
 
'.$set['review'].'
 
Tracklist
'.$set['tracklist'].'
 
 
Last update: