\n"; echo "\n"; echo "\n"; echo "Atlanta's TheaterReview.com\n"; echo "http://www.theaterreview.com\n"; echo "Reviews of Atlanta's Theater works from the unwashed masses.\n"; // pull the data // want to be able to optionally choose show opening info, review info or both. // we'll start with review info for last 10 reviews // and expand from there. if ($rev="yes") { $strQuery = "SELECT rv.*, pr.*, rt.rating, us.display_name " . "FROM production pr, prod_review rv, prod_rating rt, user us " . "WHERE rt.rating_id = rv.rating_id " . "AND pr.prod_id = rv.prod_id " . "AND us.user_id = rv.user_id " . "AND pr.allowreview = 1 " . "ORDER BY rv.timestamp DESC " . "LIMIT 3"; if (!($revresult = mysql_query($strQuery, $db))) { $error = mysql_error(); echo ("REVIEW ERROR : $error"); } while ($myreview = mysql_fetch_array($revresult)) { $coQuery = "SELECT co.* " . "FROM company co, complink cl " . "WHERE cl.prod_id = " . $myreview[prod_id] . " " . "AND co.comp_id = cl.comp_id "; //echo $coQuery."
"; if (!($coresult = mysql_query($coQuery, $db))) { $error = mysql_error(); echo ("COMPANY ERROR : $error"); } echo "\n"; echo "" . utf8_encode(htmlentities($myreview[text_header])) . "\n"; echo "".utf8_encode(htmlentities( "http://www.theaterreview.com/index.php3?productionurl=".$myreview[prod_id]."&maindata=proddetail"))."\n"; echo ""; $unixtimestamp = sql_to_unix_time2($myreview[timestamp]); $review_date = date("r", $unixtimestamp); echo "$review_date"; echo "\n"; echo ""; echo utf8_encode(htmlentities("Review of ".$myreview[title]."
")); While ($mycompany = mysql_fetch_array($coresult)) { echo utf8_encode(htmlentities("Produced by ".$mycompany[name]."
")); } echo utf8_encode(htmlentities("Review by ".$myreview[display_name]."
")); echo utf8_encode(htmlentities("

".$myreview[text]."

")); echo "\n"; echo "".utf8_encode(htmlentities( "http://www.theaterreview.com/index.php3?productionurl=".$myreview[prod_id]."&maindata=proddetail"))."\n"; echo "".$myreview[text_header]."\n"; echo "\n"; } } else { echo "No data selected for RSS feed. (&rev=yes for reviews.)
\n"; } //Ending stuff ?>