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: http://www.php.net/unsub.php

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 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: http://www.php.net/unsub.php
-

**

John Huggins
VANet

[EMAIL PROTECTED]
http://www.va.net/

**


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php