I used to always first query the value of in this case user_refs and then increment it in php
Is it possible to simply increment user refs through the update statement. So a 100 would be something like ++ ??

PHP Code:

mysql_query("UPDATE `phpbb_users` SET `user_refs` = '100' WHERE `user_id` =2 LIMIT 1 ;") or die(mysql_error()); 


UPDATE tablename SET fieldname=fieldname+1 WHERE whatever

Oberon glad you are roaming these forums

BTW
what's that in your sig??

Another little question
when using this:
mysql_query("UPDATE `phpbb_stats` SET stats_refs=stats_refs+1 WHERE `stats_day` = NOW( ) LIMIT 1 ;") or die(mysql_error());
Is there anyway i can tell mysql to create a new day if stats_day = now() returns no result?

You could probably just run the query as you have it there, then use the PHP function mysql_affected_rows() to find out how many rows got updated. I fthis is zero you can fire of another INSERT query to put the new date in.

My sig is a 'quine' - a program that prints it's own source code, including the parts that do the printing.

never even knew those excisted
both your sig as that function


Thanks