Click to See Complete Forum and Search --> : ok again lol


lukezweb
01-07-2004, 04:44 PM
in an sql database i have a tbale with three columns id, topics, threads i need to update it by one everytime someone posts i can do it all apart form one thing how can i set in the query line value=oldvalue+1?

pyro
01-07-2004, 05:29 PM
$sql = "UPDATE `tablename` SET `column_name` = `column_name` + 1 WHERE `something` = 'something';";