I just created a test table with the 3 fields and used:
where visits=visits+1
without the trailing comma and everything worked fine.
Cal
http://www.calevans.com
-Original Message-
From: Jamie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 3:52 AM
To: [EMAIL PROTECTED]
Sub
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
> > passwor
anuary 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
* 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/~topej
