im tring to get the total number of veiws per month using the following
include 'config.php';
$db = mysql_connect($db_host,$db_user,$db_pass);
$profile = $_GET['user'];
mysql_select_db ($db_name) or die ("Cannot connect to database");
$result = mysql_query("SELECT user, month, COUNT(hits) AS count FROM weekly WHERE user='$profile' GROUP BY month") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
echo $row['user'] . '-' . $row['month'] . '-' . $row['count'] . ' result(s)<br>';
}
thats half way there
gives
David -April-6 result(s)
but how can i then break this os i can place it onto a monthly graph?
Yours
David
