Re: Modify MySQL Record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
OFFEE2B14B.9BAC564B-ON85256D98.005AAEE6@keane.com">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:   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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux