[Xenon]

if you run queries with no output you can't use query_first, just use query.
Because query_first is a call of query and then uses fetch_array once.

so correct it would be:

PHP Code:

$currenthits=$DB_site->query_first("SELECT hits FROM main WHERE id=1");
$negertje=$currenthits['hits'] + 1;
$DB_site->query("UPDATE main SET hits=$negertje WHERE id=1"); 


and if you don't need your $negertje and currenthits values anymore you can save a query by doing just this:

PHP Code:

$DB_site->query("UPDATE main SET hits=hits+1 WHERE id=1");