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?
|
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';"; webdeveloper.com
Copyright Internet.com Inc., All Rights Reserved. |