+1 in mysql ?

boycoda · 09-01-2008, 02:14 PM

Hello everyone,

Say for example I have a field in a mysql row, with the value of 4. Now I want to be able to update that value to 5 in php.

What would be the best way to do that?

Remember though, that it has to +1 on to the current mysql row field value. UPDATING a field is easy, but i've not done a +1 of value before.

So say,

$age = $row['age'];

$agesplus = $newage;

$newage would be 5, but how would it do that?

maZtah · 09-01-2008, 02:23 PM

PHP Code:


			
$szQuery = sprintf("UPDATE table SET age = (age + 1) WHERE id = %d", $iId);

ETbyrne · 09-01-2008, 04:04 PM

Here's what maZtah said but just with the plain old SQL:

Code:

UPDATE my_table SET age = (age + 1) WHERE username = 'MyUserName'

boycoda · 09-02-2008, 08:35 AM

Ah that's great, thanks.