I agree mt, LET MYSQL DO THE JOB !! > > Marek's a bit more elegant, but I'm wondering when twelve of us press > the button and the database is hit bang, bang, bang. Mightn't a MySQL > autoincrement field be better, and let MySQL do the work? > > mt > > At 07:32 PM 9/24/2002 +0200, Marek Kilimajer wrote: >>Or better UPDATE table SET col = col +1 >> >>Jay Blanchard wrote: >> >>>[snip] >>>I have a field on a MySql database that is started with a 0, and I >>> want to add 1 to this field every time a button is pressed on a form. >>> So it should add one every time, like if there is 5 and you press it >>> one time it would have 6. >>>[/snip] >>> >>>1. SELECT for the current value >>>2. add 1 to the current value >>>3. UPDATE the new value >>> >>>HTH! >>> >>>Jay >>> >>>"I ain't gonna write your code for ya' or fix your computer neither" >>> >>>***************************************************** >>>* Texas PHP Developers Conf Spring 2003 * >>>* T Bar M Resort & Conference Center * >>>* New Braunfels, Texas * >>>* Contact [EMAIL PROTECTED] * >>>* * >>>* Want to present a paper or workshop? Contact now! * >>>***************************************************** >>> >>> >>> >>> >>> >> >> >>-- >>PHP General Mailing List (http://www.php.net/) >>To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php