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
