I believe Tomi Junnila meant you should try without the comma..
UPDATE users SET visits=visits+1 WHERE ...
(no comma before WHERE)
G'luck,
Peter
--
I am jealous of the first word in this sentence.
On Tue, Jan 23, 2001 at 06:27:22PM +0800, Jamie wrote:
> 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.
---------------------------------------------------------------------
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
