I have a data field 'thread_reply_count'. I want to increase the value of this data field by 1. Is this the correct code?
posted 12 years ago
no, assuming that the value is a number in the database, you'd have to lose the single quotes: ing sql = "UPDATE message_thread SET thread_reply_count = thread_reply_count + 1 WHERE thread_id = " + threadID; I also got rid of the double semi colon.