[RESOLVED] Counter problem

[OmegaB]

<?php
	require("/config/db_config.php");
	$connection = mysql_connect($db_host, $db_user, $db_password, $db_name) or die("error connecting");
	mysql_select_db($db_name, $connection);

$query= "SELECT * FROM counter";
$result = mysql_query($query, $connection) or die(mysql_error());
$views = mysql_result($result, 0, "num_views");

$views++;
$query = "UPDATE counter SET num_views = $views";

echo "This page has been viewed ".$views." times";
?>

The result in the browser when I go to counter.php is this:
This page has been viewed 1 times

But when I refresh the page... or close the browser and go to the link again
I still get 1 views. Can anyone see anything wrong

IMPORTANT NOTE: The num_views does not get updated in the database, it still remains at 0.

[OmegaB]

Silly mistake, just realized it.

Forgot to use the mysql_query function again
after redefining $query.

That is..

	$query = "UPDATE counter SET num_views = $views";
	mysql_query($query, $connection) or die (mysql_error());

[bradgrafelman]

Note that there's no reason to SELECT the data first - MySQL is smart enough to know how to add:

UPDATE counter SET num_views = num_views + 1

EDIT: Oops, disregard - didn't notice that you also displayed it afterwards.