RE: [PHP-DB] Modify MySQL Record

I'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:jroth1@telus.net] > Sent: Friday, September 05, 2003 12:35 PM > To: php-db@lists.php.net > 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" <jeffrey_n_Dyke@Keane.com> wrote in message > news:OFFEE2B14B.9BAC564B-ON85256D98.005AAEE6@keane.com... > > > > looks like you stopped putting commas after your fields at > > $field_str .= " formation = '$formation' "; > > $field_str .= " perfs = '$perfs' "; > > $field_str .= " event = '$event' "; > > $field_str .= " fluid = '$fluid' "; > > > > hth > > Jeff > > > > > > > > "Jeff" > > <jroth1@telus.net To: > php-db@lists.php.net > > > cc: > > Subject: > [PHP-DB] Modify > MySQL Record > > 09/05/2003 12:28 > > PM > > > > > > > > > > > > > > Helloooo! > > > > 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: > > > > function edit_record() { > > global $default_dbname, $gradient_tablename, > $access_log_tablename; > > global $new_lsd, $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, $pres, $tag; > > > > if(empty($kwo)) error_message('Empty Gradient!'); > > > > $link_id = db_connect($default_dbname); > > if(!$link_id) error_message(sql_error()); > > > > $field_str = ''; > > if($kwo != $new_kwo) $field_str = " kwo = '$new_kwo', "; > > if(!empty($lsd)) { > > $field_str .= " lsd = other_lsd('$lsd') "; > > } > > > > $field_str .= " kwo = '$kwo', "; > > $field_str .= " lsd = '$lsd', "; > > $field_str .= " date = '$date', "; > > $field_str .= " well = '$well', "; > > $field_str .= " field = '$field', "; > > $field_str .= " uni = '$uni', "; > > $field_str .= " license = '$license', "; > > $field_str .= " formation = '$formation' "; > > $field_str .= " perfs = '$perfs' "; > > $field_str .= " event = '$event' "; > > $field_str .= " fluid = '$fluid' "; > > $field_str .= " mode = '$mode' "; > > $field_str .= " type = '$type' "; > > $field_str .= " vhd = '$vhd' "; > > $field_str .= " file = '$file' "; > > $field_str .= " kb = '$kb' "; > > $field_str .= " grd = '$grd' "; > > $field_str .= " open = '$open' "; > > $field_str .= " sour = '$open' "; > > $field_str .= " tubing = '$tubing' "; > > $field_str .= " landed = '$landed' "; > > $field_str .= " casing = '$casing' "; > > $field_str .= " landed2 = '$landed2' "; > > $field_str .= " shut_date = '$shut_date' "; > > $field_str .= " sut_time = '$shut_time' "; > > $field_str .= " pres = '$pres' "; > > $field_str .= " tag = '$tag' "; > > > > > > $query = "UPDATE $gradient_tablename SET $field_str WHERE > kwo = '$kwo'"; > > > > $result = mysql_query($query); > > if(!$result) error_message(sql_error()); > > > > $num_rows = mysql_affected_rows($link_id); > > if(!$num_rows) error_message("Nothing changed!"); > > if($lsd != $new_kwo) { > > $query = "UPDATE $access_log_tablename SET kwo = > '$new_kwo' WHERE kwo > = > > '$kwo'"; > > $result = mysql_query($query); > > if(!$result) error_message(sql_error()); > > > > user_message("All records regarding $lsd have been changed!", > > "$PHP_SELF?action=view_record&kwo=$new_kwo"); > > } > > else { > > user_message("All records regarding $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 >