0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
) t GROUP BY t.businessid";
if ($category) { // narrow down to a particular category
$numquery = "SELECT t.* FROM (
SELECT id, businessid
FROM reviews, review_regions, review_categories
WHERE active='1'
AND businessid > 0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
AND reviews.id = review_categories.reviewid
AND category = '$category'
) t GROUP BY t.businessid";
}
if ($keyword) { // text search
$numquery = "SELECT t.* FROM (
SELECT id, businessid
FROM reviews, review_regions
WHERE active='1'
AND businessid > 0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
AND MATCH(headline, review) AGAINST('$keyword')
AND posttime >= (CURDATE() - INTERVAL 2 YEAR)
) t GROUP BY t.businessid";
}
$result = mysql_query($numquery) or die("Query failed: " . mysql_error());
$number = mysql_num_rows($result);
$localpages = ceil($number/$perpage);
$query = "SELECT t.* FROM (
SELECT businessid, reviews.id, editorid, posttime, headline, review
FROM reviews, review_regions
WHERE active='1'
AND businessid > 0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
ORDER BY posttime DESC
) t GROUP BY t.businessid
ORDER BY t.posttime DESC $limit";
if ($category) { // narrow down to a particular category
$query = "SELECT t.* FROM (
SELECT businessid, reviews.id, editorid, posttime, headline, review
FROM reviews, review_regions, review_categories
WHERE active='1'
AND businessid > 0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
AND reviews.id = review_categories.reviewid
AND category = '$category'
ORDER BY posttime DESC
) t GROUP BY t.businessid
ORDER BY t.posttime DESC $limit";
}
if ($keyword) { // text search
$query = "SELECT t.* FROM (
SELECT businessid, reviews.id, editorid, posttime, headline, review, MATCH(headline, review) AGAINST('$keyword') AS score
FROM reviews, review_regions
WHERE active='1'
AND businessid > 0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
AND MATCH(headline, review) AGAINST('$keyword')
AND posttime >= (CURDATE() - INTERVAL 2 YEAR)
ORDER BY score DESC
) t GROUP BY t.businessid
ORDER BY t.posttime DESC $limit";
}
$result = mysql_query($query) or die("Query failed: " . mysql_error());
while (list($bid, $reviewid, $editorid, $posttime, $headline, $review) = mysql_fetch_row($result)) {
$date = date_create_from_format('Y-m-d H:i:s', $posttime);
$posttime = date_format($date, 'M jS, Y');
$companyname = '';
$logo = '';
//$query2 = "SELECT companyname, logo FROM clients WHERE active='1' AND businessid='$bid'";
$query2 = "SELECT companyname, logo FROM clients WHERE businessid='$bid'"; // Sylvia now wants to display their logo, regardless of active status
$result2 = mysql_query($query2) or die("Query failed: " . mysql_error());
list($companyname, $logo) = mysql_fetch_row($result2);
$review = substr(trim(strip_tags($review)), 0, $limitreviewto) . '…';
if (strlen($headline) > $limitheadlineto) $headline = substr($headline, 0, $limitheadlineto) . '…';
?>
";
} else { // go get that editor's blog screen shot
$query2 = "SELECT blogs.bloggraphic FROM blogs, editors WHERE editors.blogid=blogs.id AND editors.id='$editorid'";
$result2 = mysql_query($query2) or die("Query failed: " . mysql_error());
list($bloggraphic) = mysql_fetch_row($result2);
if ($bloggraphic) echo "![\"Blogger\"](\"https://www.usfamilyguide.com/_blogs/$bloggraphic\") ";
else echo "![\"Blogger\"](\"img/blogger1.png\") ";
}
?>
|
By: " . $editors[$editorid]; ?>
Posted:
View All $companyname Reviews and Articles";
?>
|
-
";
} else { // go get that editor's blog screen shot
$query2 = "SELECT blogs.bloggraphic FROM blogs, editors WHERE editors.blogid=blogs.id AND editors.id='$editorid'";
$result2 = mysql_query($query2) or die("Query failed: " . mysql_error());
list($bloggraphic) = mysql_fetch_row($result2);
if ($bloggraphic) echo "
";
else echo "
";
}
?>
By: " . $editors[$editorid]; ?>
Posted:
|
View All $companyname Reviews and Articles";
?>
|
$perpage) {
?>
|
|
More Reviews
|
|
|
1) { // we will always have a first button if page > 1
echo "«";
}
if ($localpage > 1) {
echo "Previous";
}
?>
|
$maxbuttons) { // we will need to truncate the beginning page buttons
echo "$i\n";
for ($i=($localpage - $maxbuttons)+1; $i<=$localpage; $i++) {
echo "$i\n";
}
if ($i < $localpages) {
echo "$i\n";
}
}
elseif ($localpages > $maxbuttons) { // We have more pages than buttons. Show the first $maxbuttons buttons, then follow it with the '...' button.
for ($i=1; $i<=$maxbuttons; $i++) {
echo "$i\n";
}
echo "$i\n";
}
else { // We have fewer pages than buttons. Just display them all.
for ($i=1; $i<=$localpages; $i++) {
echo "$i\n";
}
}
?>
|
$localpages) $nextpage = $localpages; // but no more than we actually have
echo $nextpage;
echo "\">Next\n";
}
if ($localpage < $localpages) { // Last button
echo "»";
}
?>
|
$perpage)
?>
NATIONAL REVIEWS AND ARTICLES
0
AND national='1'
) t GROUP BY t.businessid";
if ($category) { // narrow down to a particular category
$numquery = "SELECT t.* FROM (
SELECT id, businessid
FROM reviews, review_categories
WHERE active='1'
AND businessid > 0
AND national='1'
AND reviews.id = review_categories.reviewid
AND category = '$category'
) t GROUP BY t.businessid";
}
if ($keyword) { // text search
$numquery = "SELECT t.* FROM (
SELECT id, businessid
FROM reviews
WHERE active='1'
AND businessid > 0
AND national='1'
AND MATCH(headline, review) AGAINST('$keyword')
AND posttime >= (CURDATE() - INTERVAL 2 YEAR)
) t GROUP BY t.businessid";
}
$result = mysql_query($numquery) or die("Query failed: " . mysql_error());
$number = mysql_num_rows($result);
$nationalpages = ceil($number/$perpage);
$query = "SELECT t.* FROM (
SELECT businessid, reviews.id, editorid, posttime, headline, review
FROM reviews
WHERE active='1'
AND businessid > 0
AND national='1'
ORDER BY posttime DESC
) t GROUP BY t.businessid
ORDER BY t.posttime DESC $limit";
if ($category) { // narrow down to a particular category
$query = "SELECT t.* FROM (
SELECT businessid, reviews.id, editorid, posttime, headline, review
FROM reviews, review_categories
WHERE active='1'
AND businessid > 0
AND national='1'
AND reviews.id = review_categories.reviewid
AND category = '$category'
ORDER BY posttime DESC
) t GROUP BY t.businessid
ORDER BY t.posttime DESC $limit";
}
if ($keyword) { // text search
$query = "SELECT t.* FROM (
SELECT businessid, reviews.id, editorid, posttime, headline, review, MATCH(headline, review) AGAINST('$keyword') AS score
FROM reviews
WHERE active='1'
AND businessid > 0
AND national='1'
AND MATCH(headline, review) AGAINST('$keyword')
AND posttime >= (CURDATE() - INTERVAL 2 YEAR)
ORDER BY score DESC
) t GROUP BY t.businessid
ORDER BY t.posttime DESC $limit";
}
$result = mysql_query($query) or die("Query failed: " . mysql_error());
while (list($bid, $reviewid, $editorid, $posttime, $headline, $review) = mysql_fetch_row($result)) {
$date = date_create_from_format('Y-m-d H:i:s', $posttime);
$posttime = date_format($date, 'M jS, Y');
$companyname = '';
$logo = '';
//$query2 = "SELECT companyname, logo FROM clients WHERE active='1' AND businessid='$bid'";
$query2 = "SELECT companyname, logo FROM clients WHERE businessid='$bid'"; // Sylvia now wants to display their logo, regardless of active status
$result2 = mysql_query($query2) or die("Query failed: " . mysql_error());
list($companyname, $logo) = mysql_fetch_row($result2);
$review = substr(trim(strip_tags($review)), 0, $limitreviewto) . '…';
if (strlen($headline) > $limitheadlineto) $headline = substr($headline, 0, $limitheadlineto) . '…';
?>
|
";
} else { // go get that editor's blog screen shot
$query2 = "SELECT blogs.bloggraphic FROM blogs, editors WHERE editors.blogid=blogs.id AND editors.id='$editorid'";
$result2 = mysql_query($query2) or die("Query failed: " . mysql_error());
list($bloggraphic) = mysql_fetch_row($result2);
if ($bloggraphic) echo "";
else echo "";
}
?>
|
By: " . $editors[$editorid]; ?>
Posted:
View All Reviews and Articles
|
-
";
} else { // go get that editor's blog screen shot
$query2 = "SELECT blogs.bloggraphic FROM blogs, editors WHERE editors.blogid=blogs.id AND editors.id='$editorid'";
$result2 = mysql_query($query2) or die("Query failed: " . mysql_error());
list($bloggraphic) = mysql_fetch_row($result2);
if ($bloggraphic) echo "
";
else echo "
";
}
?>
By: " . $editors[$editorid]; ?>
Posted:
|
$perpage) {
?>
|
|
More Reviews
|
|
|
1) { // we will always have a first button if page > 1
echo "«";
}
if ($nationalpage > 1) {
echo "Previous";
}
?>
|
$maxbuttons) { // we will need to truncate the beginning page buttons
echo "$i\n";
for ($i=($nationalpage - $maxbuttons)+1; $i<=$nationalpage; $i++) {
echo "$i\n";
}
if ($i < $nationalpages) {
echo "$i\n";
}
}
elseif ($nationalpages > $maxbuttons) { // We have more pages than buttons. Show the first $maxbuttons buttons, then follow it with the '...' button.
for ($i=1; $i<=$maxbuttons; $i++) {
echo "$i\n";
}
echo "$i\n";
}
else { // We have fewer pages than buttons. Just display them all.
for ($i=1; $i<=$nationalpages; $i++) {
echo "$i\n";
}
}
?>
|
$nationalpages) $nextpage = $nationalpages; // but no more than we actually have
echo $nextpage;
echo "#nationalreviews\">Next\n";
}
if ($nationalpage < $nationalpages) { // Last button
echo "»";
}
?>
|
$perpage)
?>
0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
) t GROUP BY t.editorid";
if ($category) { // narrow down to a particular category
$numquery = "SELECT t.* FROM (
SELECT id, editorid
FROM reviews, review_categories, review_regions
WHERE active='1'
AND businessid = '0'
AND editorid > 0
AND regionid='$regionid'
AND reviews.id = review_categories.reviewid
AND reviews.id = review_regions.reviewid
AND category = '$category'
) t GROUP BY t.editorid";
}
if ($keyword) { // text search
$numquery = "SELECT t.* FROM (
SELECT id, editorid
FROM reviews, review_regions
WHERE active='1'
AND businessid = '0'
AND editorid > 0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
AND MATCH(headline, review) AGAINST('$keyword')
AND posttime >= (CURDATE() - INTERVAL 2 YEAR)
) t GROUP BY t.editorid";
}
$result = mysql_query($numquery) or die("Query failed: " . mysql_error());
$number = mysql_num_rows($result);
$typeCpages = ceil($number/$perpage);
if ($number > 0) { // we have this type of review
?>
0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
ORDER BY posttime DESC
) t GROUP BY t.editorid
ORDER BY t.posttime DESC $limit";
if ($category) { // narrow down to a particular category
$query = "SELECT t.* FROM (
SELECT reviews.id, editorid, posttime, headline, review
FROM reviews, review_categories, review_regions
WHERE active='1'
AND businessid = '0'
AND editorid > 0
AND regionid='$regionid'
AND reviews.id = review_categories.reviewid
AND reviews.id = review_regions.reviewid
AND category = '$category'
ORDER BY posttime DESC
) t GROUP BY t.editorid
ORDER BY t.posttime DESC $limit";
}
if ($keyword) { // text search
$query = "SELECT t.* FROM (
SELECT reviews.id, editorid, posttime, headline, review, MATCH(headline, review) AGAINST('$keyword') AS score
FROM reviews, review_regions
WHERE active='1'
AND businessid = '0'
AND editorid > 0
AND regionid='$regionid'
AND reviews.id = review_regions.reviewid
AND MATCH(headline, review) AGAINST('$keyword')
AND posttime >= (CURDATE() - INTERVAL 2 YEAR)
ORDER BY score DESC
) t GROUP BY t.editorid
ORDER BY t.posttime DESC $limit";
}
$result = mysql_query($query) or die("Query failed: " . mysql_error());
while (list($reviewid, $editorid, $posttime, $headline, $review) = mysql_fetch_row($result)) {
$date = date_create_from_format('Y-m-d H:i:s', $posttime);
$posttime = date_format($date, 'M jS, Y');
$review = substr(trim(strip_tags($review)), 0, $limitreviewto) . '…';
if (strlen($headline) > $limitheadlineto) $headline = substr($headline, 0, $limitheadlineto) . '…';
?>
|
";
else echo "";
?>
|
By: " . $editors[$editorid]; ?>
Posted:
View All Posts
|
-
";
else echo "
";
?>
By: " . $editors[$editorid]; ?>
Posted:
|
$perpage) {
?>
|
|
More Reviews
|
|
|
1) { // we will always have a first button if page > 1
echo "«";
}
if ($typeCpage > 1) {
echo "Previous";
}
?>
|
$maxbuttons) { // we will need to truncate the beginning page buttons
echo "$i\n";
for ($i=($typeCpage - $maxbuttons)+1; $i<=$typeCpage; $i++) {
echo "$i\n";
}
if ($i < $typeCpages) {
echo "$i\n";
}
}
elseif ($typeCpages > $maxbuttons) { // We have more pages than buttons. Show the first $maxbuttons buttons, then follow it with the '...' button.
for ($i=1; $i<=$maxbuttons; $i++) {
echo "$i\n";
}
echo "$i\n";
}
else { // We have fewer pages than buttons. Just display them all.
for ($i=1; $i<=$typeCpages; $i++) {
echo "$i\n";
}
}
?>
|
$typeCpages) $nextpage = $typeCpages; // but no more than we actually have
echo $nextpage;
echo "#nonclientreviews\">Next\n";
}
if ($typeCpage < $typeCpages) { // Last button
echo "»";
}
?>
|
$perpage)
if ($number > 0) { // we have this type of review
?>
= (CURDATE() - INTERVAL 2 YEAR)";
}
$result = mysql_query($numquery) or die("Query failed: " . mysql_error());
$number = mysql_num_rows($result);
$typeDpages = ceil($number/$perpage);
if ($number > 0) { // we have this type of review
?>
= (CURDATE() - INTERVAL 2 YEAR)
ORDER BY score DESC $limit";
}
$result = mysql_query($query) or die("Query failed: " . mysql_error());
while (list($reviewid, $posttime, $headline, $review) = mysql_fetch_row($result)) {
$date = date_create_from_format('Y-m-d H:i:s', $posttime);
$posttime = date_format($date, 'M jS, Y');
$review = substr(trim(strip_tags($review)), 0, $limitreviewto) . '…';
if (strlen($headline) > $limitheadlineto) $headline = substr($headline, 0, $limitheadlineto) . '…';
?>
$perpage) {
?>
|
|
More Reviews
|
|
|
1) { // we will always have a first button if page > 1
echo "«";
}
if ($typeDpage > 1) {
echo "Previous";
}
?>
|
$maxbuttons) { // we will need to truncate the beginning page buttons
echo "$i\n";
for ($i=($typeDpage - $maxbuttons)+1; $i<=$typeDpage; $i++) {
echo "$i\n";
}
if ($i < $typeDpages) {
echo "$i\n";
}
}
elseif ($typeDpages > $maxbuttons) { // We have more pages than buttons. Show the first $maxbuttons buttons, then follow it with the '...' button.
for ($i=1; $i<=$maxbuttons; $i++) {
echo "$i\n";
}
echo "$i\n";
}
else { // We have fewer pages than buttons. Just display them all.
for ($i=1; $i<=$typeDpages; $i++) {
echo "$i\n";
}
}
?>
|
$typeDpages) $nextpage = $typeDpages; // but no more than we actually have
echo $nextpage;
echo "#nonbloggernonclientreviews\">Next\n";
}
if ($typeDpage < $typeDpages) { // Last button
echo "»";
}
?>
|
$perpage)
?>
0) { // we have this type of review
?>
