[PHP MySQL] Query Problems

programming
1

Alright, I am trying to make a script that will automaticly update some URL’s in a table. I’ve used this format of a query in order to get the content before, but this time its only returning the number of entries in the table.


             $query = "SELECT COUNT(*) AS url FROM urls";
	if ($r = mysql_query($query)) {
		while ($row = mysql_fetch_array ($r)) {
			$url = $row['url'];
			echo "$url";
			$gather = new Harvest_Keywords($url);
			$gather->process();
		}
	} else {
		die ('Error: ' . mysql_error() . '');
	}

Any ideas on what I’m doing wrong?