The Toy Man $award $year

"; } else { // echo "The Toy Man - Product Guide $product_guide_year"; echo "Product Reviews Repository - Search Results"; } ?>


The Toy Man

The Toy Man $award $year

"; } ?> $award Recipients

"; } ?>
"0") {echo "safe yes";} // echo strlen($s); // if all criteria is empty, go back if ( (strlen($s) < "4") and ($category=="") and ($product_rating=="") and ($educational_value=="") and ($design_quality=="") and ($simplicity=="") and ($visual_appeal=="") and ($funfactor=="") and ($safety=="") ) { // echo "dead"; //empty // go back // exit; echo ""; } //echo "date"; //echo $year; //echo substr($year,0,4); // initial sql // ==================== if ( $award == "Seal of Approval" ) { //$sql="select * from ttmo_product_reviews where (show_review='yes') and (substr(review_date,1,4)='$year') "; //echo "soa"; //echo $year; $sql="select * from ttmo_product_reviews where (show_review='yes') and (review_date like '$year-%') and (product_rating > '2') "; } if ( $award == "Award of Excellence" ) { //$sql="select * from ttmo_product_reviews where (show_review='yes') and (substr(review_date,1,4)='$year') "; //echo "aoe"; $sql="select * from ttmo_product_reviews where (show_review='yes') and (review_date like '$year-%') and ( product_rating = '5') "; } if ( $award == "eChoice Awards" ) { //$sql="select * from ttmo_product_reviews where (show_review='yes') and (substr(review_date,1,4)='$year') "; $sql="select * from ttmo_product_reviews where (show_review='yes') and (review_date like '$year-%') and ( echoice_award = 'yes') "; } if ( $award == "" ) { $sql="select * from ttmo_product_reviews where (show_review='yes') "; } // s if ( strlen($s) > "3" ) { $sql = $sql." and ((product_review_title like '%$s%') or (review_paragraph1 like '%$s%') or (review_paragraph2 like '%$s%') or (review_paragraph3 like '%$s%'))"; } // category if ( $category!="" ) { $sql = $sql. " and ((category like '$category%') or (category2 like '$category%') or (category3 like '$category%')) "; } // just cat // if ( (strlen($s) < "4") and ($category != "") ) // { // $sql="select * from ttmo_product_reviews where (show_review='yes') and ( (category like '$category')) "; //$sql="select * from ttmo_product_reviews where (show_review='yes') and ((product_review_title like '%$s%') or (review_paragraph1 like '%$s%') or (category like '$category')) "; // } //just s // if ( (strlen($s) > "3") and ($category == "") ) // { // $sql="select * from ttmo_product_reviews where (show_review='yes') and ((product_review_title like '%$s%') or (review_paragraph1 like '%$s%')) "; // } else // { //// echo ""; // } // both s and cat // if ( (strlen($s) > "3") and ($category != "") ) // { ////echo "s and cat"; // $sql="select * from ttmo_product_reviews where (show_review='yes') and ((product_review_title like '%$s%') or (review_paragraph1 like '%$s%') and (category like '$category')) "; // } // rating sql building if ( $product_rating > "0") { $sql = $sql."and (product_rating=$product_rating) "; } if ( $educational_value > "0") { $sql = $sql."and (educational_value=$educational_value) "; } if ( $design_quality > "0") { $sql = $sql."and (design_quality=$design_quality) "; } if ( $simplicity > "0") { $sql = $sql."and (simplicity=$simplicity) "; } if ( $visual_appeal > "0") { $sql = $sql."and (visual_appeal=$visual_appeak) "; } if ( $funfactor > "0") { $sql = $sql."and (funfactor=$funfactor) "; } if ( $safety > "0") { //echo "safe yes"; $sql = $sql."and (safety=$safety) "; } // sql should now be defined or auto go back if ( $sql =="" ) { //echo "in sql area "; // $msg="No Matches Were Found."; echo ""; } // override tests // $sql="select * from ttmo_product_reviews where (show_review='yes') and ( (category like '$category')) "; // $sql="select * from ttmo_product_reviews where (show_review='yes') and ((product_review_title like '%$s%') or (review_paragraph1 like '%$s%') or (category like '$category')) "; // $sql="select * from ttmo_product_reviews where (show_review='yes') and ((product_review_title like '%$s%') or (review_paragraph1 like '%$s%')) "; //echo $sql; //echo $s; //echo $category; //echo "---------"; // $sql="select * from product_reviews where category = '$c' "; //echo "zzzzz"; //echo $sql; //echo "yyyyy"; // get sql result $result = mysql_query($sql,$db); // get count and if 0, go back // sql should now be defined or auto go back $num_rows = mysql_num_rows($result); //echo "ccccccccccccc"; //echo $num_rows; if ( $num_rows =="0" ) { //echo "0 count "; $msg="No Matches Were Found."; echo $msg; echo ""; } while ($myrow = mysql_fetch_array($result)) { // echo "."; $pin_review=$myrow["pin_review"]; $review_date=$myrow["review_date"]; $category=$myrow["category"]; $category2=$myrow["category2"]; $category3=$myrow["category3"]; $echoice_award=$myrow["echoice_award"]; $product_directory_name=$myrow["product_directory_name"]; $main_graphic=$myrow["main_graphic"]; $product_title=$myrow["product_title"]; $product_summary=$myrow["product_summary"]; $product_msrp=$myrow["product_msrp"]; $product_url=$myrow["product_url"]; $product_rating=$myrow["product_rating"]; $product_graphic=$myrow["product_graphic"]; $product_review_title=$myrow["product_review_title"]; $product_quote=$myrow["product_quote"]; $product_introduction=$myrow["product_introduction"]; $review_author_html=$myrow["review_author_html"]; $review_title1=$myrow["review_title1"]; $review_paragraph1=$myrow["review_paragraph1"]; $review_title2=$myrow["review_title2"]; $review_paragraph2=$myrow["review_paragraph2"]; $review_title3=$myrow["review_title3"]; $review_paragraph3=$myrow["review_paragraph3"]; $review_title4=$myrow["review_title4"]; $review_paragraph4=$myrow["review_paragraph4"]; $review_title5=$myrow["review_title5"]; $review_paragraph5=$myrow["review_paragraph5"]; ?>
The Toy Man Product Reviews Database Search Results"; } else { echo "The Toy Man Reviews Repository - Search Results"; } ?>
Product Primary Category
$product_review_title"; ?>

lastline is: $last_line"; // include("/home/testpositiveimagenews/www/cgi-bin/search_positiveimagenews_html.cgi"); ?>