include('../common.php');
mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$vars->title = "Reviews";
$vars->menu = array(
array("/", "Home"),
);
$url_name = $_GET["n"];
if (!isset($url_name))
$url_name = '';
$truncate = true;
if ($url_name != '') {
$query = "SELECT title, url_name, subhead, rating, rating_desc, image, reviewer, date_created, GROUP_CONCAT(CONCAT('',tag,'') ORDER BY tag SEPARATOR ', ') AS tag, copy FROM review r INNER JOIN map_item_tag mit ON r.reviewID = mit.itemID AND itemType = 'review' INNER JOIN tags t ON t.tagID = mit.tagID WHERE date_created <= NOW() AND url_name = '" . $url_name . "' GROUP BY title, url_name, subhead, rating, rating_desc, image, reviewer, date_created ORDER BY date_created DESC, reviewID;";
$vars->title = ucwords(str_replace('_',' ',$url_name));
$truncate = false;
} else {
$query = "SELECT title, url_name, subhead, rating, rating_desc, image, reviewer, date_created, GROUP_CONCAT(CONCAT('',tag,'') ORDER BY tag SEPARATOR ', ') AS tag, copy FROM review r INNER JOIN map_item_tag mit ON r.reviewID = mit.itemID AND itemType = 'review' INNER JOIN tags t ON t.tagID = mit.tagID WHERE date_created <= NOW() GROUP BY title, url_name, subhead, rating, rating_desc, image, reviewer, date_created ORDER BY date_created DESC, reviewID LIMIT 1;";
}
header('Content-Type: text/html; charset=ISO-8859-1');
include('../header.php');
$result = mysql_query($query);
$query = "SELECT * FROM review WHERE date_created < NOW() ORDER BY date_created DESC;";
$list = mysql_query($query);
?>