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); ?>