I no longer have the original post in my inbox, I had a problem with
fetchmail which downloaded all the messages a couple hundred times, so i
did a mass delete.
All you should have to do is wrap the statement in () like:
UPDATE <table name> SET field=(field+1) WHERE <where clause>
This will work fine from PHP using something like
<? mysql_query ("UPDATE page_views SET hits=(hits+1) where pageid='$page_id'") ?>
Hope this helps you,
Stewart
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
