Re: mySQL query question

If you're just adding one, there is no reason to retrieve the data, process it, and update it. You can just update the number. http://dev.mysql.com/doc/refman/5.0/en/update.html Also, you should read the MySQL manual on default values: http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Michael S. Dunsavage wrote: > okay I want to pull an integer from a database called confirm_number, > add 1 and repost it back to the database > > > here's the code I'm using. > > > $queryconfirm="SELECT confirm_number from contacts ORDER BY contact DESC > LIMIT 1"; > $confirmresult=$queryconfirm; > > now here's the problem > > I want to add 1 to confirm_number: > > $confirm_number=$confirmresult; > $confirm_number+=1; > > Now all this does is set the confirm_number record to 1 in the database. > So I assume that $queryconfirm somehow is not being passed to > confirm_number? But, while we're here the confirm_number is supposed to > be 5 digits long and the +1 should make it 10001, 10002, 10003 etc > > how would I set the original number to 1000 to begin with? Or should I > just set that in the database record its self when I'm ready to use the > website? >