Welcome to our site!

"; */ require_once("templates/IndexTemplate.php");?>
"; // TOP 10 /*$q1 = "update yellow_agents SET AccountStatus='active' WHERE username='test'"; $r1 = mysql_query($q1) or die(mysql_error());*/ if($aset[Sitefee]=="1") { $q1 = "select * from yellow_agents, yellow_posts,yellow_categories,yellow_subcat where yellow_posts.CategoryID = yellow_categories.CategoryID and yellow_agents.AccountStatus = 'active' and yellow_posts.SubCategoryID = yellow_subcat.subcatid and yellow_posts.AgentID=yellow_agents.AgentID order by yellow_agents.RegDate desc limit 0,5 "; } else { $q1 = "select * from yellow_agents, yellow_posts,yellow_categories,yellow_subcat where yellow_posts.CategoryID = yellow_categories.CategoryID and yellow_agents.AccountStatus = 'active' and yellow_posts.SubCategoryID = yellow_subcat.subcatid and yellow_posts.AgentID=yellow_agents.AgentID order by yellow_agents.RegDate desc limit 0,5 "; //$q1 = "select * from yellow_agents, yellow_priority, yellow_categories,yellow_subcat where yellow_agents.CategoryID = yellow_categories.CategoryID and yellow_agents.PriorityLevel = yellow_priority.PriorityLevel and yellow_agents.AccountStatus = 'active' and yellow_agents.SubCategoryID = yellow_subcat.subcatid order by yellow_agents.RegDate desc limit 0,7 "; } $r1 = mysql_query($q1) or die(mysql_error()); $lrows = mysql_num_rows($r1); if($lrows > '0') { $i = 0; while($a1 = mysql_fetch_array($r1)) { $rate="SELECT avg(rated) as abcde FROM yellow_rating where mediaid ='$a1[AgentID]' GROUP BY mediaid"; $rank=""; $rateq=mysql_query($rate)or die($rate); $rateline=mysql_fetch_array($rateq); $count=5; $ListingTable .= "
\n\t"; $i++; /* if(!empty($a1[logo])) { $images = explode("|", $a1[logo]); $MyImage = $images[0]; $ListingTable .= ""; } else { $ListingTable .= ""; } */ $ListingTable .= "
\"\"$a1[CompanyName]
Category: $a1[CategoryName]>>$a1[description]$a1[subcatname]\n"; $ShortDesc = substr($a1[DetailedDesc], 0, 200); if(!empty($ShortDesc)) { $ListingTable .= "
$ShortDesc\n"; } $ListingTable .="
"; } } ?>
"; require_once("templates/ArticleTemplate.php"); //echo "
"; require_once("templates/LatestTemplateMain.php"); require_once("templates/FooterTemplate.php"); ?>