INDEPENDENT AND UNBIASED - LUXURY TRAVELS REVIEWS 'THE PLAIN AND SIMPLE TRUTH'



'Tours, Cruises and Airlines' ORDER BY region", $db); while ($region=mysql_fetch_assoc($regionQuery)){ $regionId=$region['regionid']; //$countryQuery=mysql_query("SELECT * FROM country as ,countryicons as b WHERE a.countryid=b.countryid and a.regionid=$regionId ORDER BY country ASC", $db); //echo "SELECT * FROM country as ,countryicons as b WHERE a.countryid=b.countryid and a.regionid=$regionId ORDER BY country ASC"; $countryQuery=mysql_query("SELECT * FROM country WHERE regionid=$regionId ORDER BY country ASC", $db); $randomReviewQueryForImage=mysql_query("SELECT * FROM reviewplace WHERE regionid=$regionId ORDER BY RAND()", $db); while($randomReview=mysql_fetch_assoc($randomReviewQueryForImage)){ $randomReviewid=$randomReview['reviewid']; $checkImage=mysql_query("SELECT * FROM images WHERE reviewid=$randomReviewid AND section='place' AND rate='5'", $db); if (mysql_num_rows($checkImage)>0) { //$randomImage=mysql_fetch_assoc(mysql_query("SELECT * FROM images WHERE reviewid=$randomReviewid AND section='place' AND rate='5' ORDER BY RAND() LIMIT 1", $db)); } } $sql_randomImage="SELECT * FROM countryicons WHERE id=$regionId ORDER BY RAND() LIMIT 3"; $randomImage=mysql_query($sql_randomImage,$db) or die(mysql_error()); // Run the query. $count=mysql_num_rows($randomImage); //echo "SELECT * FROM countryicons WHERE id=$regionId ORDER BY RAND() LIMIT 1"; //echo "count".$count; ?>

0) { while ($image=mysql_fetch_assoc($randomImage)) { ?>
<? echo $image['label']; ?>
 

 
value:".$i % 2; $i=$i+1; } ?>