I found the problem - it was in an include file, not with the script. It
had a variable that should have been changed from $address1 to $address,
but wasn't in that one particular file.
Anyway, thanks for the replies.
--
Chip
Victor Pendleton <VPendleton@stripped> wrote on 08/18/2004 01:09:25 PM:
> Can you log on as the web account and try to insert, update, select
directly
> from the MySQL monitor?
>
> -----Original Message-----
> From: Chip Wiegand
> To: Victor Pendleton <VPendleton
> Cc: 'mysql@stripped '
> Sent: 8/18/04 2:41 PM
> Subject: RE: I can delete, add, but not update
>
> Victor Pendleton <VPendleton@stripped> wrote on 08/17/2004 10:54:14
> AM:
>
> > Are there any errors being caught by the web form or being logged to
> the
> > MySQL error log?
>
> I checked the log, there are no errors listed at all. It looks okay. No
> error message appears when running the script. I double checked my
> update
> script to make sure there were no spelling errors in the field names,
> and
> all looks good. It's just really strange.
> --
> Chip
>
> > -----Original Message-----
> > From: Chip Wiegand
> > To: mysql@stripped
> > Sent: 8/17/04 11:29 AM
> > Subject: I can delete, add, but not update
> >
> > I don't know for sure, but I think I may have something wrong with
> > permissions in MySQL. I have some web forms from which I can add new
> > data
> > and delete data. But when I try to do an update of existing data the
> > data
> > is not actually changed. Is it possible that the permissions are not
> set
> >
> > up correctly in MySQL?
> > Thanks,
> > Chip Wiegand
> > Computer Services
> > Simrad, Inc
> > 425-778-8821
> > 425-771-7211 (FAX)
> >
>
| Thread |
|---|
| • I can delete, add, but not update | Chip Wiegand | 17 Aug |
| • Re: I can delete, add, but not update | Rhino | 17 Aug |
| • RE: I can delete, add, but not update | Victor Pendleton | 17 Aug |
| • RE: I can delete, add, but not update | Chip Wiegand | 18 Aug |
| • RE: I can delete, add, but not update | Victor Pendleton | 18 Aug |
| • RE: I can delete, add, but not update | Chip Wiegand | 18 Aug |