John -

...and then John Clegg said...
% 
% I was wondering if there is a php / mysql function call that will 
% increment an integer column in a database.
% ie. the equivalent to
%    $foo++;

I didn't see that, but you can at least let mysql do the math:

  update tablename set field = field + 1 where condition

Just make sure you don't forget "where condition" :-)  And beware that if
you have a timestamp field in the table you'll need to set it to itself
in order to avoid updating it.


% 
% Cheers
% 
% John Clegg


HTH & HAND

:-D
-- 
David T-G                      * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

Attachment: pgp00000.pgp
Description: PGP signature

Reply via email to