$data = "select count(id) as total, to_member, avg(votes) as votes from voting group by to_member order by votes DESC limit 40"; $result = mysql_query($data) or die (mysql_error()); $num= 1; $nums = array(); $names = array(); while($ratings = mysql_fetch_assoc($result)) { $rateavg =$ratings['votes']; $votename =$ratings['to_member']; $total =$ratings['total']; //echo "&num=".$num."
"; //echo "&votename=".$votename."
"; $nums[] = $num; $names[] = $votename; } $url = "&num=" . implode(":", $nums) . "&name=" . implode(":", $names); echo $url;