simple counter script won't work??

[blowhole]

Need some general opinion as to what is wrong with this piece of code. Any suggestion appreciated in advance.

<?php
$connection = mysql_connect("localhost","server" ,"password") or die ("Cannot make that connection");
$db = mysql_select_db("database");
$result = mysql_query("SELECT * FROM atable");
$fields = mysql_fetch_row($result);
mysql_query("UPDATE atable SET field=field+1");
$thecount0 = $result->record["one"];
$thecount1 = $fields[];
print ($thecount0);
print ($thecount1);
?>

Neither of these approaches works. it returns a null and does not update the db at all and so forth.

Any clues??

[Lars_Berg]

You should always check for errors after a database call.

$result = mysql_query("SELECT * FROM table") or die mysql_error();

//
mysql_query("UPDATE table SET field=field+1") or die mysql_error();
// 
$thecount1 = $fields[0]; 

Hint: Table is a reserved word in SQL.

[blowhole]

The sql error function provides no information for me. Just informs me what line the parsing is failing on.
Everything else works. I am at a loss as to why it is not working.

Its a simple table named counters. The table has a field called one that is a smallint, 10, unsigned.
Anything else would be appreciated.