I've been trying a variety of things with it incl. 'visits+1' , (visits+1)
, ('visits+1') , 'visits=visits+1' and not quotes or commas
still doesn't seem to work.
-----Original Message-----
From: Tomi Junnila [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 23 January 2001 6:02 PM
To: [EMAIL PROTECTED]
Subject: Re: Update and change a value
* Jamie <[EMAIL PROTECTED]> wrote on 23.01.01 11:51:
> UPDATE users SET visits=visits+1, WHERE user_id='$user' AND
> password='$password'
If that comma after +1 is not a typo in the mail, then that's what's causing
the problem.
--
Tomi Junnila <[EMAIL PROTECTED]>
http://www.badzilla.net/~topeju/
Electronics and Information Technology,
University of Turku, Finland
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
