Re: Modify MySQL Record

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

 



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