Return-Path: Envelope-To: robert@seabreeze.asn.au X-Spam-Status: SpamAssassin Failed Received: from pb1.pair.com ([216.92.131.4] verified) by hermajestystheatre.com.au (CommuniGate Pro SMTP 4.1.3) with SMTP id 335994 for robert@seabreeze.asn.au; Sat, 06 Sep 2003 05:57:40 +1000 Received: (qmail 99389 invoked by uid 1010); 5 Sep 2003 20:01:53 -0000 Mailing-List: contact php-db-help@lists.php.net; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Delivered-To: mailing list php-db@lists.php.net Received: (qmail 99376 invoked by uid 1010); 5 Sep 2003 20:01:53 -0000 Delivered-To: ezmlm-scan-php-db@lists.php.net Delivered-To: ezmlm-php-db@lists.php.net MIME-Version: 1.0 Message-Id: <3F58EB4F.000001.02176@fsoto1> Date: Fri, 5 Sep 2003 14:00:15 -0600 (Mountain Daylight Time) Content-Type: Multipart/related; type="multipart/alternative"; boundary="------------Boundary-00=_FKBRQL80000000000000" X-Mailer: IncrediMail 2001 (2001155.2001155) From: "Fernando Soto" References: <20030905191517.34160.qmail@pb1.pair.com> X-FID: FLAVOR00-NONE-0000-0000-000000000000 X-FVER: X-CNT: ; X-Priority: 3 To: , Subject: Re: [PHP-DB] Modify MySQL Record --------------Boundary-00=_FKBRQL80000000000000 Content-Type: Multipart/Alternative; boundary="------------Boundary-00=_GKBRLVC0000000000000" --------------Boundary-00=_GKBRLVC0000000000000 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable When you have an auntoincremente field in your table, you don't have to especify the field name in the query, as the following:=0D =0D =0D $query =3D "INSERT INTO cnrl_db (kwo, lsd, date, well, field, uni,=0D license, formation, perfs, event, fluid, mode, type, vhd, file, kb, grd,=0D open, sour, tube, landed, casing, landed2, shut_date, shut_time, pres, ta= g)=0D VALUES ('$kwo', '$lsd', '$date', '$well', '$field', '$uni',=0D '$license', '$formation', '$perfs', '$event', '$fluid', '$mode', '$type',= =0D '$vhd', '$file', '$kb', '$grd', '$open', '$sour', '$tube', '$landed',=0D '$casing', '$landed2', '$shut_date', '$shut_time', '$pres', '$tag')";=0D =0D hope it helps=0D eLFeR.....=0D =0D -------Original Message-------=0D =0D From: Jeff=0D Date: Viernes, 05 de Septiembre de 2003 01:15:21 p.m.=0D To: php-db@lists.php.net=0D Subject: Re: [PHP-DB] Modify MySQL Record=0D =0D Ok, so I added what you suggested, but it still doesn't assign any number= s=0D to the records.=0D =0D $query =3D "INSERT INTO cnrl_db (gradient, kwo, lsd, date, well, field, u= ni,=0D license, formation, perfs, event, fluid, mode, type, vhd, file, kb, grd,=0D open, sour, tube, landed, casing, landed2, shut_date, shut_time, pres, ta= g)=0D VALUES ('NULL', '$kwo', '$lsd', '$date', '$well', '$field', '$uni',=0D '$license', '$formation', '$perfs', '$event', '$fluid', '$mode', '$type',= =0D '$vhd', '$file', '$kb', '$grd', '$open', '$sour', '$tube', '$landed',=0D '$casing', '$landed2', '$shut_date', '$shut_time', '$pres', '$tag')";=0D $result =3D mysql_query($query, $link_id) OR die(mysql_error());=0D =0D gradient - the auto increment field.=0D =0D =0D =0D "Richard Hutchins" wrote in message=0D news:1EA7D3AE70ACD511BE6D006097A78C1E033C92B8@USROCEXC...=0D > Jeff,=0D >=0D > When you want to increment an autoincrement field, you just put NULL in= to=0D > the query. For example:=0D >=0D > INSERT (NULL,'Jeff','php list','Modify MySQL Record') INTO mail;=0D >=0D > Where NULL is in the same spot in the field list as your autoincrement=0D > field.=0D >=0D > That concept is covered in the MySQL manual. Pretty simple stuff. If=0D you're=0D > in a situation where you have an autoincrement field that you sometimes= =0D > autoincrement and sometimes manually assign a value to, I think you're=0D > misusing the autoincrement field (IMHO). If you have that situation, us= e=0D the=0D > autoincrement field to assign a unique ID to the table row and use a=0D > separate field with another name for the manually assigned data.=0D >=0D > As far as the stuff you mentioned about clicking things and getting the= =0D > messages you expected, I'm kinda' lost. But if you use the autoincremen= t=0D > field as it is intended, the logic should present itself.=0D >=0D > > -----Original Message-----=0D > > From: Jeff [mailto:jroth1@telus.net]=0D > > Sent: Friday, September 05, 2003 2:07 PM=0D > > To: php-db@lists.php.net=0D > > Subject: Re: [PHP-DB] Modify MySQL Record=0D > >=0D > >=0D > > Ok, so it sorta works now *grin*=0D > >=0D > > Two new problems=0D > >=0D > > I added an auto increment field in my table and changed the=0D > > php to reflect=0D > > that field - But for some reason, it doesn't work..=0D > > When I submit a new record, do I need to tell SQL to add one to the=0D > > greatest, or should it do it automatically when a new record=0D > > is created?=0D > > gradient MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,=0D > > and I made it the primary.=0D > >=0D > > Problem two,=0D > >=0D > > If I manually enter a number into that field, I can make=0D > > changes to the=0D > > record no problem! but... it goes into some kind of=0D > > continuous loop. It=0D > > comes up with a window that says what I told it to say --=0D > > user_message("All=0D > > records regarding $kwo have been changed!",=0D > >=0D > > "$PHP_SELF?action=3Dview_record&gradient=3D$new_gradient"); --=0D > > I hit OK and it jumps to -- if(empty($kwo)) error_message('Empty=0D > > Gradient!!'); -- if you hit ok again, it just loops.=0D > >=0D > > This might be solved as soon as I get that one field to auto=0D > > populate. :P=0D > >=0D > >=0D > > "Richard Hutchins" wrote in message= =0D > > news:1EA7D3AE70ACD511BE6D006097A78C1E033C92B2@USROCEXC...=0D > > > Jeff,=0D > > >=0D > > > No problem. Happens to everyone, trust me.=0D > > >=0D > > > Anyway, I see you're using mysql_affected_rows($link_id) to=0D > > get see how=0D > > many=0D > > > rows were affected by the UPDATE. Try getting rid of the=0D > > $link_id in the=0D > > > declaration and just use mysql_affected_rows(). Personally,=0D > > I have always=0D > > > had trouble when specifying a resource in a mysql function=0D > > like this (it's=0D > > > probably just me). But, the mysql_affected_rows() function will, by= =0D > > default,=0D > > > use the last connection used by your script.=0D > > >=0D > > > Also, you're checking to see if it's not set e.g.,:=0D > > >=0D > > > > > > > $num_rows =3D mysql_affected_rows($link_id);=0D > > > > > > > if(!$num_rows) error_message("Nothing changed!");=0D > > >=0D > > > According to the documentation, mysql_affected_rows()=0D > > returns a -1 if the=0D > > > query failed. And I'm pretty sure it returns 0 if your query was=0D > > successful=0D > > > but didn't affect any rows. I'm pretty sure ! checks for=0D > > FALSE which is=0D > > not=0D > > > one of mysql_affected_rows() valid return values. So your=0D > > check isn't=0D > > doing=0D > > > what you think it should.=0D > > >=0D > > > Give that a shot and see if it helps out at all.=0D > > >=0D > > > Good luck.=0D > > >=0D > > > Rich=0D > > >=0D > > > > -----Original Message-----=0D > > > > From: Jeff [mailto:jroth1@telus.net]=0D > > > > Sent: Friday, September 05, 2003 12:44 PM=0D > > > > To: php-db@lists.php.net=0D > > > > Subject: Re: [PHP-DB] Modify MySQL Record=0D > > > >=0D > > > >=0D > > > > K, my tired eyes last night missed a few stupid mistakes...=0D > > > >=0D > > > > First: The Commas=0D > > > > Second: I removed the period form the first line of the array=0D > > > > -- $field_str=0D > > > > =3D " kwo =3D '$kwo', ";=0D > > > > Third: two typos.=0D > > > >=0D > > > > *hangs head in shame*=0D > > > >=0D > > > > Sorry for bothering everyone. :P=0D > > > >=0D > > > > BUT! I'm still having a problem - when I try to submit the=0D > > > > change it comes=0D > > > > back and says "Nothing Changed!" even if I change every field.=0D > > > >=0D > > > > Gonna do some more hunting - I'm doubting myself now. ;)=0D > > > >=0D > > > >=0D > > > >=0D > > > >=0D > > > > "Richard Hutchins" =0D > > wrote in message=0D > > > > news:1EA7D3AE70ACD511BE6D006097A78C1E033C92B1@USROCEXC...=0D > > > > > I'd suggest you first output your SQL statement to the=0D > > > > browser to see=0D > > > > > exactly what it's sending to the database. Might give you=0D > > > > the answer right=0D > > > > > there.=0D > > > > >=0D > > > > > > -----Original Message-----=0D > > > > > > From: Jeff [mailto:jroth1@telus.net]=0D > > > > > > Sent: Friday, September 05, 2003 12:35 PM=0D > > > > > > To: php-db@lists.php.net=0D > > > > > > Subject: Re: [PHP-DB] Modify MySQL Record=0D > > > > > >=0D > > > > > >=0D > > > > > > Yah, I noticed that after I had submitted this, and fixed it=0D > > > > > > - still no=0D > > > > > > change - gives the same exact error.=0D > > > > > >=0D > > > > > > "Jeffrey N Dyke" wrote in message=0D > > > > > > news:OFFEE2B14B.9BAC564B-ON85256D98.005AAEE6@keane.com...=0D > > > > > > >=0D > > > > > > > looks like you stopped putting commas after your fields at=0D > > > > > > > $field_str .=3D " formation =3D '$formation' ";=0D > > > > > > > $field_str .=3D " perfs =3D '$perfs' ";=0D > > > > > > > $field_str .=3D " event =3D '$event' ";=0D > > > > > > > $field_str .=3D " fluid =3D '$fluid' ";=0D > > > > > > >=0D > > > > > > > hth=0D > > > > > > > Jeff=0D > > > > > > >=0D > > > > > > >=0D > > > > > > >=0D > > > > > > > "Jeff"=0D > > > > > > > > > > > > php-db@lists.php.net=0D > > > > > > > > cc:=0D > > > > > > > Subject:=0D > > > > > > [PHP-DB] Modify=0D > > > > > > MySQL Record=0D > > > > > > > 09/05/2003 12:28=0D > > > > > > > PM=0D > > > > > > >=0D > > > > > > >=0D > > > > > > >=0D > > > > > > >=0D > > > > > > >=0D > > > > > > >=0D > > > > > > > Helloooo!=0D > > > > > > >=0D > > > > > > > I'm having a small problem with modifying the data in a=0D > > > > MySQL DB.=0D > > > > > > >=0D > > > > > > > And here's the error:=0D > > > > > > >=0D > > > > > > > (After I click the "Submit Changes" button) Error: 1064:=0D > > > > > > You have an error=0D > > > > > > > in your SQL syntax near '(10-10-10-10)' kwo=3D'1235',=0D > > > > > > lsd=3D'10-10-10-10',=0D > > > > > > > date=3D'2003-05-05', well' at line 1=0D > > > > > > >=0D > > > > > > > Here's the code:=0D > > > > > > >=0D > > > > > > > function edit_record() {=0D > > > > > > > global $default_dbname, $gradient_tablename,=0D > > > > > > $access_log_tablename;=0D > > > > > > > global $new_lsd, $kwo, $lsd, $date, $well, $field,=0D > > > > > > > $uni, $license, $formation, $perfs, $event,=0D > > $fluid, $mode,=0D > > > > > > > $type, $vhd, $file, $kb, $grd, $open, $sour, $tube,=0D > > > > > > > $landed, $casing, $landed2, $shut_date, $shut_time,=0D > > > > $pres, $tag;=0D > > > > > > >=0D > > > > > > > if(empty($kwo)) error_message('Empty Gradient!');=0D > > > > > > >=0D > > > > > > > $link_id =3D db_connect($default_dbname);=0D > > > > > > > if(!$link_id) error_message(sql_error());=0D > > > > > > >=0D > > > > > > > $field_str =3D '';=0D > > > > > > > if($kwo !=3D $new_kwo) $field_str =3D " kwo =3D '$new_kwo',= ";=0D > > > > > > > if(!empty($lsd)) {=0D > > > > > > > $field_str .=3D " lsd =3D other_lsd('$lsd') ";=0D > > > > > > > }=0D > > > > > > >=0D > > > > > > > $field_str .=3D " kwo =3D '$kwo', ";=0D > > > > > > > $field_str .=3D " lsd =3D '$lsd', ";=0D > > > > > > > $field_str .=3D " date =3D '$date', ";=0D > > > > > > > $field_str .=3D " well =3D '$well', ";=0D > > > > > > > $field_str .=3D " field =3D '$field', ";=0D > > > > > > > $field_str .=3D " uni =3D '$uni', ";=0D > > > > > > > $field_str .=3D " license =3D '$license', ";=0D > > > > > > > $field_str .=3D " formation =3D '$formation' ";=0D > > > > > > > $field_str .=3D " perfs =3D '$perfs' ";=0D > > > > > > > $field_str .=3D " event =3D '$event' ";=0D > > > > > > > $field_str .=3D " fluid =3D '$fluid' ";=0D > > > > > > > $field_str .=3D " mode =3D '$mode' ";=0D > > > > > > > $field_str .=3D " type =3D '$type' ";=0D > > > > > > > $field_str .=3D " vhd =3D '$vhd' ";=0D > > > > > > > $field_str .=3D " file =3D '$file' ";=0D > > > > > > > $field_str .=3D " kb =3D '$kb' ";=0D > > > > > > > $field_str .=3D " grd =3D '$grd' ";=0D > > > > > > > $field_str .=3D " open =3D '$open' ";=0D > > > > > > > $field_str .=3D " sour =3D '$open' ";=0D > > > > > > > $field_str .=3D " tubing =3D '$tubing' ";=0D > > > > > > > $field_str .=3D " landed =3D '$landed' ";=0D > > > > > > > $field_str .=3D " casing =3D '$casing' ";=0D > > > > > > > $field_str .=3D " landed2 =3D '$landed2' ";=0D > > > > > > > $field_str .=3D " shut_date =3D '$shut_date' ";=0D > > > > > > > $field_str .=3D " sut_time =3D '$shut_time' ";=0D > > > > > > > $field_str .=3D " pres =3D '$pres' ";=0D > > > > > > > $field_str .=3D " tag =3D '$tag' ";=0D > > > > > > >=0D > > > > > > >=0D > > > > > > > $query =3D "UPDATE $gradient_tablename SET $field_str WHERE= =0D > > > > > > kwo =3D '$kwo'";=0D > > > > > > >=0D > > > > > > > $result =3D mysql_query($query);=0D > > > > > > > if(!$result) error_message(sql_error());=0D > > > > > > >=0D > > > > > > > $num_rows =3D mysql_affected_rows($link_id);=0D > > > > > > > if(!$num_rows) error_message("Nothing changed!");=0D > > > > > > > if($lsd !=3D $new_kwo) {=0D > > > > > > > $query =3D "UPDATE $access_log_tablename SET kwo =3D=0D > > > > > > '$new_kwo' WHERE kwo=0D > > > > > > =3D=0D > > > > > > > '$kwo'";=0D > > > > > > > $result =3D mysql_query($query);=0D > > > > > > > if(!$result) error_message(sql_error());=0D > > > > > > >=0D > > > > > > > user_message("All records regarding $lsd have been=0D > > > > changed!",=0D > > > > > > >=0D > > "$PHP_SELF?action=3Dview_record&kwo=3D$new_kwo");=0D > > > > > > > }=0D > > > > > > > else {=0D > > > > > > > user_message("All records regarding $lsd have been=0D > > > > changed!");=0D > > > > > > > }=0D > > > > > > > }=0D > > > > > > >=0D > > > > > > > --=0D > > > > > > > PHP Database Mailing List (http://www.php.net/)=0D > > > > > > > To unsubscribe, visit: http://www.php.net/unsub.php=0D > > > > > >=0D > > > > > > --=0D > > > > > > PHP Database Mailing List (http://www.php.net/)=0D > > > > > > To unsubscribe, visit: http://www.php.net/unsub.php=0D > > > > > >=0D > > > >=0D > > > > --=0D > > > > PHP Database Mailing List (http://www.php.net/)=0D > > > > To unsubscribe, visit: http://www.php.net/unsub.php=0D > > > >=0D > >=0D > > --=0D > > PHP Database Mailing List (http://www.php.net/)=0D > > To unsubscribe, visit: http://www.php.net/unsub.php=0D > >=0D =0D --=0D PHP Database Mailing List (http://www.php.net/)=0D To unsubscribe, visit: http://www.php.net/unsub.php=0D =0D =0D =2E --------------Boundary-00=_GKBRLVC0000000000000 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
When you have an auntoincremente field in your table, you don't= have to especify the field name in the query, as the following= :
 
 
$query =3D "INSERT INTO cnrl_db (kwo, lsd, date, well, field, uni,
license, formation, perfs, event, fluid, mode, type, vhd, file, kb, = grd,
open, sour, tube, landed, casing, landed2, shut_date, shut_time, pre= s, tag)
VALUES ('$kwo', '$lsd', '$date', '$well', '$field', '$uni',
'$license', '$formation', '$perfs', '$event', '$fluid', '$mode', '$t= ype',
'$vhd', '$file', '$kb', '$grd', '$open', '$sour', '$tube', '$landed'= ,
'$casing', '$landed2', '$shut_date', '$shut_time', '$pres', '$tag')"= ;
 
hope it helps
eLFeR.....
 
-------Original Message-------
 
From: Jeff
Date: Viernes, 05 = de Septiembre de 2003 01:15:21 p.m.
Subject: Re: [PHP-= DB] Modify MySQL Record
 
Ok, so I added what you suggested, but it still doesn't assign any n= umbers
to the records.
 
$query =3D "INSERT INTO cnrl_db (gradient, kwo, lsd, date, well, fie= ld, uni,
license, formation, perfs, event, fluid, mode, type, vhd, file, kb, = grd,
open, sour, tube, landed, casing, landed2, shut_date, shut_time, pre= s, tag)
VALUES ('NULL', '$kwo', '$lsd', '$date', '$well', '$field', '$uni',<= /DIV>
'$license', '$formation', '$perfs', '$event', '$fluid', '$mode', '$t= ype',
'$vhd', '$file', '$kb', '$grd', '$open', '$sour', '$tube', '$landed'= ,
'$casing', '$landed2', '$shut_date', '$shut_time', '$pres', '$tag')"= ;
     $result =3D mysql_query($query, $link_id) O= R die(mysql_error());
 
gradient - the auto increment field.
 
 
 
"Richard Hutchins" <Richard.Hutchins@Getingeusa.com> wrote in message
news:1EA7D3AE70ACD511BE6D006097A78C1E033C92B8@USROCEXC...
> Jeff,
>
> When you want to increment an autoincrement field, you just put= NULL into
> the query. For example:
>
> INSERT (NULL,'Jeff','php list','Modify MySQL Record') INTO mail= ;
>
> Where NULL is in the same spot in the field list as your autoin= crement
> field.
>
> That concept is covered in the MySQL manual. Pretty simple stuf= f. If
you're
> in a situation where you have an autoincrement field that you s= ometimes
> autoincrement and sometimes manually assign a value to, I think= you're
> misusing the autoincrement field (IMHO). If you have that situa= tion, use
the
> autoincrement field to assign a unique ID to the table row and = use a
> separate field with another name for the manually assigned data= =2E
>
> As far as the stuff you mentioned about clicking things and get= ting the
> messages you expected, I'm kinda' lost. But if you use the auto= increment
> field as it is intended, the logic should present itself.
>
> > -----Original Message-----
> > From: Jeff [mailto:jro= th1@telus.net]
> > Sent: Friday, September 05, 2003 2:07 PM
> > Subject: Re: [PHP-DB] Modify MySQL Record
> >
> >
> > Ok, so it sorta works now *grin*
> >
> > Two new problems
> >
> > I added an auto increment field in my table and changed th= e
> > php to reflect
> > that field - But for some reason, it doesn't work..
> > When I submit a new record, do I need to tell SQL to add o= ne to the
> > greatest, or should it do it automatically when a new reco= rd
> > is created?
> > gradient MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT= ,
> > and I made it the primary.
> >
> > Problem two,
> >
> > If I manually enter a number into that field, I can make
> > changes to the
> > record no problem! but... it goes into some kind of
> > continuous loop. It
> > comes up with a window that says what I told it to say --<= /DIV>
> > user_message("All
> > records regarding $kwo have been changed!",
> >
> > "$PHP_SELF?action=3Dview_record&gradient=3D$new_gradie= nt"); --
> > I hit OK and it jumps to -- if(empty($kwo)) error_message(= 'Empty
> > Gradient!!'); -- if you hit ok again, it just loops.
> >
> > This might be solved as soon as I get that one field to au= to
> > populate. :P
> >
> >
> > "Richard Hutchins" <Richard.Hutchins@Getingeusa.com> wrote in message<= /DIV>
> > news:1EA7D3AE70ACD511BE6D006097A78C1E033C92B2@USROCEXC...<= /DIV>
> > > Jeff,
> > >
> > > No problem. Happens to everyone, trust me.
> > >
> > > Anyway, I see you're using mysql_affected_rows($link_= id) to
> > get see how
> > many
> > > rows were affected by the UPDATE. Try getting rid of = the
> > $link_id in the
> > > declaration and just use mysql_affected_rows(). Perso= nally,
> > I have always
> > > had trouble when specifying a resource in a mysql fun= ction
> > like this (it's
> > > probably just me). But, the mysql_affected_rows() fun= ction will, by
> > default,
> > > use the last connection used by your script.
> > >
> > > Also, you're checking to see if it's not set e.g.,:
> > >
> > > > > > > $num_rows =3D mysql_affected_rows= ($link_id);
> > > > > > > if(!$num_rows) error_message("Not= hing changed!");
> > >
> > > According to the documentation, mysql_affected_rows()=
> > returns a -1 if the
> > > query failed. And I'm pretty sure it returns 0 if you= r query was
> > successful
> > > but didn't affect any rows. I'm pretty sure ! 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-----
> > > > From: Jeff [= mailto:jroth1@telus.net]
> > > > Sent: Friday, September 05, 2003 12:44 PM
> > > > Subject: Re: [PHP-DB] Modify MySQL Record
> > > >
> > > >
> > > > K, my tired eyes last night missed a few stupid = mistakes...
> > > >
> > > > First: The Commas
> > > > Second: I removed the period form the first line= of the array
> > > > -- $field_str
> > > > =3D " kwo =3D '$kwo', ";
> > > > Third: two typos.
> > > >
> > > > *hangs head in shame*
> > > >
> > > > Sorry for bothering everyone. :P
> > > >
> > > > BUT! I'm still having a problem - when I try to = submit the
> > > > change it comes
> > > > back and says "Nothing Changed!" even if I chang= e every field.
> > > >
> > > > Gonna do some more hunting - I'm doubting myself= now. ;)
> > > >
> > > >
> > > >
> > > >
> > > > "Richard Hutchins" <Richard.Hutchins@Getingeusa.com>
> > wrote in message
> > > > news:1EA7D3AE70ACD511BE6D006097A78C1E033C92B1@US= ROCEXC...
> > > > > I'd suggest you first output your SQL state= ment 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:jroth1@telus.net]
> > > > > > Sent: Friday, September 05, 2003 12:35= PM
> > > > > > To: php-db@lists.php.net
> > > > > > Subject: Re: [PHP-DB] Modify MySQL Rec= ord
> > > > > >
> > > > > >
> > > > > > Yah, I noticed that after I had submit= ted this, and fixed it
> > > > > > - still no
> > > > > > change - gives the same exact error.
> > > > > >
> > > > > > "Jeffrey N Dyke" <jeffrey_n_Dyke@Keane.com> wrote in mess= age
> > > > > > >
> > > > > > > looks like you stopped putting co= mmas after your fields at
> > > > > > > $field_str .=3D " formation =3D '= $formation' ";
> > > > > > > $field_str .=3D " perfs =3D '$per= fs' ";
> > > > > > > $field_str .=3D " event =3D '$eve= nt' ";
> > > > > > > $field_str .=3D " fluid =3D '$flu= id' ";
> > > > > > >
> > > > > > > hth
> > > > > > > Jeff
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Jeff"
> > > > > > > <jroth1@telus.net To:
> > > > > > > > cc:
> > > > > > > Subject:
> > > > > > [PHP-DB] Modify
> > > > > > MySQL Record
> > > > > > > 09/05/2003 12:28
> > > > > > > PM
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Helloooo!
> > > > > > >
> > > > > > > I'm having a small problem with m= odifying the data in a
> > > > MySQL DB.
> > > > > > >
> > > > > > > And here's the error:
> > > > > > >
> > > > > > > (After I click the "Submit Change= s" button) Error: 1064:
> > > > > > You have an error
> > > > > > > in your SQL syntax near '(10-10-1= 0-10)' kwo=3D'1235',
> > > > > > lsd=3D'10-10-10-10',
> > > > > > > date=3D'2003-05-05', well' at lin= e 1
> > > > > > >
> > > > > > > Here's the code:
> > > > > > >
> > > > > > > function edit_record() {
> > > > > > > global $default_dbname, $gradient= _tablename,
> > > > > > $access_log_tablename;
> > > > > > > global $new_lsd, $kwo, $lsd, $dat= e, $well, $field,
> > > > > > > $uni, $license, $formation, $perf= s, $event,
> > $fluid, $mode,
> > > > > > > $type, $vhd, $file, $kb, $grd, $o= pen, $sour, $tube,
> > > > > > > $landed, $casing, $landed2, $shut= _date, $shut_time,
> > > > $pres, $tag;
> > > > > > >
> > > > > > > if(empty($kwo)) error_message('Em= pty Gradient!');
> > > > > > >
> > > > > > > $link_id =3D db_connect($default_= dbname);
> > > > > > > if(!$link_id) error_message(sql_e= rror());
> > > > > > >
> > > > > > > $field_str =3D '';
> > > > > > > if($kwo !=3D $new_kwo) $field_str= =3D " kwo =3D '$new_kwo', ";
> > > > > > > if(!empty($lsd)) {
> > > > > > > $field_str .=3D " lsd =3D other_l= sd('$lsd') ";
> > > > > > > }
> > > > > > >
> > > > > > > $field_str .=3D " kwo =3D '$kwo',= ";
> > > > > > > $field_str .=3D " lsd =3D '$lsd',= ";
> > > > > > > $field_str .=3D " date =3D '$date= ', ";
> > > > > > > $field_str .=3D " well =3D '$well= ', ";
> > > > > > > $field_str .=3D " field =3D '$fie= ld', ";
> > > > > > > $field_str .=3D " uni =3D '$uni',= ";
> > > > > > > $field_str .=3D " license =3D '$l= icense', ";
> > > > > > > $field_str .=3D " formation =3D '= $formation' ";
> > > > > > > $field_str .=3D " perfs =3D '$per= fs' ";
> > > > > > > $field_str .=3D " event =3D '$eve= nt' ";
> > > > > > > $field_str .=3D " fluid =3D '$flu= id' ";
> > > > > > > $field_str .=3D " mode =3D '$mode= ' ";
> > > > > > > $field_str .=3D " type =3D '$type= ' ";
> > > > > > > $field_str .=3D " vhd =3D '$vhd' = ";
> > > > > > > $field_str .=3D " file =3D '$file= ' ";
> > > > > > > $field_str .=3D " kb =3D '$kb' ";=
> > > > > > > $field_str .=3D " grd =3D '$grd' = ";
> > > > > > > $field_str .=3D " open =3D '$open= ' ";
> > > > > > > $field_str .=3D " sour =3D '$open= ' ";
> > > > > > > $field_str .=3D " tubing =3D '$tu= bing' ";
> > > > > > > $field_str .=3D " landed =3D '$la= nded' ";
> > > > > > > $field_str .=3D " casing =3D '$ca= sing' ";
> > > > > > > $field_str .=3D " landed2 =3D '$l= anded2' ";
> > > > > > > $field_str .=3D " shut_date =3D '= $shut_date' ";
> > > > > > > $field_str .=3D " sut_time =3D '$= shut_time' ";
> > > > > > > $field_str .=3D " pres =3D '$pres= ' ";
> > > > > > > $field_str .=3D " tag =3D '$tag' = ";
> > > > > > >
> > > > > > >
> > > > > > > $query =3D "UPDATE $gradient_tabl= ename SET $field_str WHERE
> > > > > > kwo =3D '$kwo'";
> > > > > > >
> > > > > > > $result =3D mysql_query($query);<= /DIV>
> > > > > > > if(!$result) error_message(sql_er= ror());
> > > > > > >
> > > > > > > $num_rows =3D mysql_affected_rows= ($link_id);
> > > > > > > if(!$num_rows) error_message("Not= hing changed!");
> > > > > > > if($lsd !=3D $new_kwo) {
> > > > > > > $query =3D "UPDATE $access_log_ta= blename SET kwo =3D
> > > > > > '$new_kwo' WHERE kwo
> > > > > > =3D
> > > > > > > '$kwo'";
> > > > > > > $result =3D mysql_query($query);<= /DIV>
> > > > > > > if(!$result) error_message(sql_er= ror());
> > > > > > >
> > > > > > > user_message("All records regardi= ng $lsd have been
> > > > changed!",
> > > > > > >
> > "$PHP_SELF?action=3Dview_record&kwo=3D$new_kwo");
> > > > > > > }
> > > > > > > else {
> > > > > > > user_message("All records regardi= ng $lsd have been
> > > > changed!");
> > > > > > > }
> > > > > > > }
> > > > > > >
> > > > > > > --
> > > > > > > PHP Database Mailing List (http://www.php.net/)
> > > > > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > > > >
> > > > > > --
> > > > > > PHP Database Mailing List (http://www.php.net/)
> > > > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
 
--
PHP Database Mailing List (http://ww= w.php.net/)
To unsubscribe, visit: http= ://www.php.net/unsub.php
 
 
.
______________________= ______________________________
<= A href=3D"http://www.incredimail.com/redir.asp?ad_id=3D309&lang=3D9">= 3D""  IncrediMail - Email has= finally evolved - = Click Here --------------Boundary-00=_GKBRLVC0000000000000-- --------------Boundary-00=_FKBRQL80000000000000--