RE: Update and change a value

2001-01-23 Thread Cal Evans
] Subject: Update and change a value I was wondering if anyone can explain why this SQL command doesn't work UPDATE users SET visits=visits+1, WHERE user_id='$user' AND password='$password' the $user and $password are variables that are inserted by PHP, what I'm specifi

Re: Update and change a value

2001-01-23 Thread Peter Pentchev
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

RE: Update and change a value

2001-01-23 Thread Jamie
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

Re: Update and change a value

2001-01-23 Thread Tomi Junnila
* 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

Update and change a value

2001-01-23 Thread Jamie
I was wondering if anyone can explain why this SQL command doesn't work UPDATE users SET visits=visits+1, WHERE user_id='$user' AND password='$password' the $user and $password are variables that are inserted by PHP, what I'm specifically looking at is the visits=visits+1 which is simple enough