thing i have to do was to try it in MySQL and fortunately it works.
Anyway, Jeff have 2 options to select, right?...
eLFeR
---Original Message---
From: Hutchins, Richard
Date: Viernes, 05 de Septiembre de 2003 02:19:23 p.m.
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Modify M
ssage-
From: Fernando Soto [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 4:00 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Modify MySQL Record
When you have an auntoincremente field in your table, you don't have to
especify the field name in the que
x27;$mode', '$type',
'$vhd', '$file', '$kb', '$grd', '$open', '$sour', '$tube', '$landed',
'$casing', '$landed2', '$shut_date', '$shut_time', '$pres', '$tag&
;s supposed to be sending.
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 05, 2003 3:15 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Modify MySQL Record
>
>
> Ok, so I added what you suggested, but it still doesn'
to the table row and use a
> separate field with another name for the manually assigned data.
>
> As far as the stuff you mentioned about clicking things and getting the
> messages you expected, I'm kinda' lost. But if you use the autoincrement
> field as it is intended,
as it is intended, the logic should present itself.
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 05, 2003 2:07 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Modify MySQL Record
>
>
> Ok, so it sorta works now *grin*
>
> T
e ! checks for FALSE which is
not
> one of mysql_affected_rows() valid return values. So your check isn't
doing
> what you think it should.
>
> Give that a shot and see if it helps out at all.
>
> Good luck.
>
> Rich
>
> > -Original Message
; browser to see
> > exactly what it's sending to the database. Might give you
> the answer right
> > there.
> >
> > > -Original Message-
> > > From: Jeff [mailto:[EMAIL PROTECTED]
> > > Sent: Friday, September 05, 2003 12:35 PM
>
x27;d suggest you first output your SQL statement to the browser to see
> exactly what it's sending to the database. Might give you the answer right
> there.
>
> > -Original Message-
> > From: Jeff [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 05, 2003
L PROTECTED]
> Subject: Re: [PHP-DB] Modify MySQL Record
>
>
> Yah, I noticed that after I had submitted this, and fixed it
> - still no
> change - gives the same exact error.
>
> "Jeffrey N Dyke" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PR
"Jeff"
> <[EMAIL PROTECTED] To:
[EMAIL PROTECTED]
> >cc:
>Subject: [PHP-DB] Modify
MySQL Record
> 09/05/2003 12:28
>
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
>cc:
Hell!
I'm having a small problem with modifying the data in a MySQL DB.
And here's the error:
(After I click the "Submit Changes" button) Error: 1064: You have an error
in your SQL syntax near '(10-10-10-10)' kwo='1235', lsd='10-10-10-10',
date='2003-05-05', well' at line 1
Here's the code:
13 matches
Mail list logo