require("/srv/www/htdocs/web35/html/twiturl.inc.php"); $query="SELECT * , COUNT( * ) FROM twiturl_visits v, twiturl_urls u WHERE (v.timestamp like '2008-%') AND ((u.id LIKE v.url_id) AND (u.hide LIKE '0')) GROUP BY v.url_id ORDER BY COUNT( * ) DESC LIMIT 0,1"; $tmp_query=mysql_query("$query") or die (mysql_error()); while ($row = mysql_fetch_array($tmp_query)) { $url_count=$row["COUNT( * )"]; $info_query=mysql_query("SELECT * FROM twiturl_urls WHERE id LIKE '$row[url_id]' AND hide LIKE '0'"); while ($raw = mysql_fetch_array($info_query)) { $url_id=$raw["id"]; $url_url=$raw["url"]; $url_code=$raw["code"]; } print "