Why won't this work???

obrienkev

hi all,

the below code is a simple count function. It is supposed to update the simplecount table each time the page is visited.

However, the code gives the final result of 0 rows updated.

Why is this?

Thanks.

<?php
	echo 'hello';

	// Database connection
	@ $db = mysql_pconnect('localhost', 'user', 'pword');

	if (!$db)
	{
		echo 'Could not connect';
		exit;
	}

	mysql_select_db('test') or die ('No Database');

	$query = "update simplecount set count = count+1";
	$result = mysql_query($query) or die(mysql_error());

	if ($result)
	{
		echo mysql_affected_rows().' inserted into DB';
	}



?>

jonno946

try renaming your count column.

i beleive it is a mysqql reserved word.

obrienkev

Nope. didn't work.

Any ideas??

My table has two fields:

count int (default value = 0)
count_id int (default value =1)

Drakla

This might be a complete 'Oh Christ' moment, but is there an entry in the table?

Because to start the whole ball rolling you should have one entry with a value of zero

thorpe

you said you changed your column name. does this meen your columns are still?

count int (default value = 0)
count_id int (default value =1)

'count' is, a reserved word.