Re: [PHP] Incrementing a table cell

2002-06-28 Thread Marek Kilimajer
you can use: UPDATE column SET column + 1 WHERE condition JJ Harrison wrote: what is the best way to increment a mySQL table cell? is there a increment function or do I need to increment it in php? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] Incrementing a table cell

2002-06-28 Thread John S. Huggins
Table fubar ID, SomeNumber 1 456 2 123 3 3 4 4589 $query = UPDATE fubar SET SomeNumber = SomeNumber+1 WHERE ID = 2; Result Table fubar ID, SomeNumber 1 456 2 124 3 3 4 4589 On Fri, 28 Jun 2002, JJ Harrison wrote: -what is the best way to increment a mySQL