View Single Post

  #3 (permalink)  
Old 11-09-2007
Captain Paralytic
 
Posts: n/a
Default Re: UPDATE'ing with multiple WHERES

On 9 Nov, 03:55, Austin Pickett <phr...@gmail.com> wrote:
> So essentially I'm making a basic user online script with a timeout.
> However, it doesn't seem to be working and I feel that my problem lies
> within the UPDATE statement which updates a certain selection of
> multiple 'WHERE's
>
> The code:
>
> UPDATE list SET on='1' WHERE user='$user' AND user_logged<$timeout
>
> If anyone with some experience with this could take a look, much would
> be appreciated.
>
> Thanks!


"it doesn't seem to be working"
Wow, very informative! In what bl**dy way doesn't it seem to be
working!
Is there a syntax error?
Is/are the wrong row/rows getting updated?
Is nothing getting updated?

How the h*ll do you expect anyone to be able to actually answer your
question when you don't even say what the problem is!!!!!

Think before you write!

Reply With Quote