$rateqry="SELECT * , avg(rated) AS abcde FROM yellow_rating, yellow_agents,yellow_categories,yellow_posts WHERE yellow_posts.PostID = yellow_rating.mediaid and yellow_posts.CategoryID=yellow_categories.CategoryID and yellow_posts.AgentID=yellow_agents.AgentID GROUP BY mediaid order by abcde desc LIMIT 0 , 10 "; $rateq=mysql_query($rateqry)or die($rateqry); ?>
Category |
Title |
Added |
Ad Expires |
Price |
Rating |
---|---|---|---|---|---|
=date('m-d-y',$rateline[PostDate]);?> |
=date('m-d-y',$rateline[ExpDate]);?> |
Rs. =$rateline[Price]?> |
$count=1;
$rank="";
while($count<=round($rateline[abcde]))
{
$rank.= "";
$count=$count+1;
}?>=$rank?> |