Page 1 of 1

How to update tables with table name contains '.', 'space' /

Posted: Sun Jul 19, 2009 1:31 pm
by monindra1984
Now tables which is created is below...

Code: Select all

CREATE  TABLE  `logistics`.`contact_rate` (  `CAT` varchar( 100  )  NOT  NULL ,
 `JEEP` double default  '0',
 `GYPSY` double default  '0',
 `BUS` double default  '0',
 `MC` double default  '0',
 `1 TON` double default  '0',
 `TR 2.5` double default  '0',
 `CAR STAFF` double default  '0',
 `LY 3 TON` double default  '0',
 `TATA 4.5 TON` double default  '0',
 `ALS/ MOD ALS` double default  '0',
 `FOL BROWER` double default  '0',
 `SCANIA GTV` double default  '0',
 `LOADER SCANIA` double default  '0',
 `AMN SCANIA` double default  '0',
 `URAL` double default  '0',
 `LRV 3 TON` double default  '0',
 `LRV ALS` double default  '0',
 `HRV` double default  '0',
 `KRAZ` double default  '0',
 `LY 10 TON 6x6` double default  '0',
 `KOLOSTATRA 6X6` double default  '0',
 `TATRA 8X8` double default  '0',
 `JCB` double default  '0',
 `WH DOZER` double default  '0',
 `TRACTOR` double default  '0',
 `TATRA 10X10` double default  '0',
 `TATRA 10X 10 LV` double default  '0',
 `TATRA 10X 10 TLV` double default  '0',
 `TATRA 4X 4 MET SPL VEH` double default  '0',
 `TATRA 6X 6 CSV` double default  '0',
 `TATRA 6X 6 WKSP` double default  '0',
 `TATRA 8X 8 AMN` double default  '0',
 `BMP` double default  '0',
 `ALS THIRD LINE` double default  '0',
 `WATER BROWSER 3 TON` double default  '0',
 `WATER BROWSER 2.5 TON` double default  '0',
 PRIMARY  KEY (  `CAT`  )  ) ENGINE  =  MyISAM  DEFAULT CHARSET  = latin1;
The values were inserted and when i tried to edit to table by changing all the values in a row by taking input from forms.
But the values are not getting updated where ever fields name contain 'space', '.', and '/'

the program is as below:-

Code: Select all

<?php require_once('../Connections/Logistics.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE contact_rate SET JEEP=%s, GYPSY=%s, BUS=%s, MC=%s, `1 TON`=%s, `TR 2.5`=%s, `CAR STAFF`=%s, `LY 3 TON`=%s, `TATA 4.5 TON`=%s, `ALS/ MOD ALS`=%s, `FOL BROWER`=%s, `SCANIA GTV`=%s, `LOADER SCANIA`=%s, `AMN SCANIA`=%s, URAL=%s, `LRV 3 TON`=%s, `LRV ALS`=%s, HRV=%s, KRAZ=%s, `LY 10 TON 6x6`=%s, `KOLOSTATRA 6X6`=%s, `TATRA 8X8`=%s, JCB=%s, `WH DOZER`=%s, TRACTOR=%s, `TATRA 10X10`=%s, `TATRA 10X 10 LV`=%s, `TATRA 10X 10 TLV`=%s, `TATRA 4X 4 MET SPL VEH`=%s, `TATRA 6X 6 CSV`=%s, `TATRA 6X 6 WKSP`=%s, `TATRA 8X 8 AMN`=%s, BMP=%s, `ALS THIRD LINE`=%s, `WATER BROWSER 3 TON`=%s, `WATER BROWSER 2.5 TON`=%s WHERE CAT=%s",
                       GetSQLValueString($_POST['JEEP'], "double"),
                       GetSQLValueString($_POST['GYPSY'], "double"),
                       GetSQLValueString($_POST['BUS'], "double"),
                       GetSQLValueString($_POST['MC'], "double"),
                       GetSQLValueString($_POST['1 TON'], "double"),
                       GetSQLValueString($_POST['TR 25'], "double"),
                       GetSQLValueString($_POST['CAR STAFF'], "double"),
                       GetSQLValueString($_POST['LY 3 TON'], "double"),
                       GetSQLValueString($_POST['TATA 45 TON'], "double"),
                       GetSQLValueString($_POST['ALS MOD ALS'], "double"),
                       GetSQLValueString($_POST['FOL BROWER'], "double"),
                       GetSQLValueString($_POST['SCANIA GTV'], "double"),
                       GetSQLValueString($_POST['LOADER SCANIA'], "double"),
                       GetSQLValueString($_POST['AMN SCANIA'], "double"),
                       GetSQLValueString($_POST['URAL'], "double"),
                       GetSQLValueString($_POST['LRV 3 TON'], "double"),
                       GetSQLValueString($_POST['LRV ALS'], "double"),
                       GetSQLValueString($_POST['HRV'], "double"),
                       GetSQLValueString($_POST['KRAZ'], "double"),
                       GetSQLValueString($_POST['LY 10 TON 6x6'], "double"),
                       GetSQLValueString($_POST['KOLOSTATRA 6X6'], "double"),
                       GetSQLValueString($_POST['TATRA 8X8'], "double"),
                       GetSQLValueString($_POST['JCB'], "double"),
                       GetSQLValueString($_POST['WH DOZER'], "double"),
                       GetSQLValueString($_POST['TRACTOR'], "double"),
                       GetSQLValueString($_POST['TATRA 10X10'], "double"),
                       GetSQLValueString($_POST['TATRA 10X 10 LV'], "double"),
                       GetSQLValueString($_POST['TATRA 10X 10 TLV'], "double"),
                       GetSQLValueString($_POST['TATRA 4X 4 MET SPL VEH'], "double"),
                       GetSQLValueString($_POST['TATRA 6X 6 CSV'], "double"),
                       GetSQLValueString($_POST['TATRA 6X 6 WKSP'], "double"),
                       GetSQLValueString($_POST['TATRA 8X 8 AMN'], "double"),
                       GetSQLValueString($_POST['BMP'], "double"),
                       GetSQLValueString($_POST['ALS THIRD LINE'], "double"),
                       GetSQLValueString($_POST['WATER BROWSER 3 TON'], "double"),
                       GetSQLValueString($_POST['WATER BROWSER 25 TON'], "double"),
                       GetSQLValueString('contact_rate', "text"));
 
  mysql_select_db($database_Logistics, $Logistics);
  $Result1 = mysql_query($updateSQL, $Logistics) or die(mysql_error());
}
 
mysql_select_db($database_Logistics, $Logistics);
$query_contact = "SELECT * FROM contact_rate";
$contact = mysql_query($query_contact, $Logistics) or die(mysql_error());
$row_contact = mysql_fetch_assoc($contact);
$totalRows_contact = mysql_num_rows($contact);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
 
<body>
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
  <table align="center">
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">CAT:</td>
      <td><?php echo $row_contact['CAT']; ?></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">JEEP:</td>
      <td><input type="text" name="JEEP" value="<?php echo htmlentities($row_contact['JEEP'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">GYPSY:</td>
      <td><input type="text" name="GYPSY" value="<?php echo htmlentities($row_contact['GYPSY'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">BUS:</td>
      <td><input type="text" name="BUS" value="<?php echo htmlentities($row_contact['BUS'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">MC:</td>
      <td><input type="text" name="MC" value="<?php echo htmlentities($row_contact['MC'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">1 TON:</td>
      <td><input type="text" name="1 TON" value="<?php echo htmlentities($row_contact['1 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TR 2.5:</td>
      <td><input type="text" name="TR 25" value="<?php echo htmlentities($row_contact['TR 2.5'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">CAR STAFF:</td>
      <td><input type="text" name="CAR STAFF" value="<?php echo htmlentities($row_contact['CAR STAFF'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">LY 3 TON:</td>
      <td><input type="text" name="LY 3 TON" value="<?php echo htmlentities($row_contact['LY 3 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TATA 4.5 TON:</td>
      <td><input type="text" name="TATA 45 TON" value="<?php echo htmlentities($row_contact['TATA 4.5 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">ALS/ MOD ALS:</td>
      <td><input type="text" name="ALS MOD ALS" value="<?php echo htmlentities($row_contact['ALS/ MOD ALS'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">FOL BROWER:</td>
      <td><input type="text" name="FOL BROWER" value="<?php echo htmlentities($row_contact['FOL BROWER'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">SCANIA GTV:</td>
      <td><input type="text" name="SCANIA GTV" value="<?php echo htmlentities($row_contact['SCANIA GTV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">LOADER SCANIA:</td>
      <td><input type="text" name="LOADER SCANIA" value="<?php echo htmlentities($row_contact['LOADER SCANIA'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">AMN SCANIA:</td>
      <td><input type="text" name="AMN SCANIA" value="<?php echo htmlentities($row_contact['AMN SCANIA'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">URAL:</td>
      <td><input type="text" name="URAL" value="<?php echo htmlentities($row_contact['URAL'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">LRV 3 TON:</td>
      <td><input type="text" name="LRV 3 TON" value="<?php echo htmlentities($row_contact['LRV 3 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">LRV ALS:</td>
      <td><input type="text" name="LRV ALS" value="<?php echo htmlentities($row_contact['LRV ALS'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">HRV:</td>
      <td><input type="text" name="HRV" value="<?php echo htmlentities($row_contact['HRV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">KRAZ:</td>
      <td><input type="text" name="KRAZ" value="<?php echo htmlentities($row_contact['KRAZ'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">LY 10 TON 6x6:</td>
      <td><input type="text" name="LY 10 TON 6x6" value="<?php echo htmlentities($row_contact['LY 10 TON 6x6'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">KOLOSTATRA 6X6:</td>
      <td><input type="text" name="KOLOSTATRA 6X6" value="<?php echo htmlentities($row_contact['KOLOSTATRA 6X6'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TATRA 8X8:</td>
      <td><input type="text" name="TATRA 8X8" value="<?php echo htmlentities($row_contact['TATRA 8X8'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">JCB:</td>
      <td><input type="text" name="JCB" value="<?php echo htmlentities($row_contact['JCB'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">WH DOZER:</td>
      <td><input type="text" name="WH DOZER" value="<?php echo htmlentities($row_contact['WH DOZER'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TRACTOR:</td>
      <td><input type="text" name="TRACTOR" value="<?php echo htmlentities($row_contact['TRACTOR'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TATRA 10X10:</td>
      <td><input type="text" name="TATRA 10X10" value="<?php echo htmlentities($row_contact['TATRA 10X10'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TATRA 10X 10 LV:</td>
      <td><input type="text" name="TATRA 10X 10 LV" value="<?php echo htmlentities($row_contact['TATRA 10X 10 LV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TATRA 10X 10 TLV:</td>
      <td><input type="text" name="TATRA 10X 10 TLV" value="<?php echo htmlentities($row_contact['TATRA 10X 10 TLV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TATRA 4X 4 MET SPL VEH:</td>
      <td><input type="text" name="TATRA 4X 4 MET SPL VEH" value="<?php echo htmlentities($row_contact['TATRA 4X 4 MET SPL VEH'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TATRA 6X 6 CSV:</td>
      <td><input type="text" name="TATRA 6X 6 CSV" value="<?php echo htmlentities($row_contact['TATRA 6X 6 CSV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TATRA 6X 6 WKSP:</td>
      <td><input type="text" name="TATRA 6X 6 WKSP" value="<?php echo htmlentities($row_contact['TATRA 6X 6 WKSP'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">TATRA 8X 8 AMN:</td>
      <td><input type="text" name="TATRA 8X 8 AMN" value="<?php echo htmlentities($row_contact['TATRA 8X 8 AMN'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">BMP:</td>
      <td><input type="text" name="BMP" value="<?php echo htmlentities($row_contact['BMP'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">ALS THIRD LINE:</td>
      <td><input type="text" name="ALS THIRD LINE" value="<?php echo htmlentities($row_contact['ALS THIRD LINE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">WATER BROWSER 3 TON:</td>
      <td><input type="text" name="WATER BROWSER 3 TON" value="<?php echo htmlentities($row_contact['WATER BROWSER 3 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">WATER BROWSER 2.5 TON:</td>
      <td><input type="text" name="WATER BROWSER 25 TON" value="<?php echo htmlentities($row_contact['WATER BROWSER 2.5 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">&nbsp;</td>
      <td><input type="submit" value="Update record" /></td>
    </tr>
  </table>
  <input type="hidden" name="MM_update" value="form1" />
  <input type="hidden" name="CAT" value="<?php echo $row_contact['CAT']; ?>" />
</form>
<p>&nbsp;</p>
</body>
</html>
<?php
mysql_free_result($contact);
?>
 
Pls tell me how to update the table..its not getting updated... I am not aware of anyother syntax.. i need it immediately.. with anticipation..


Monindra Masia..

Re: How to update tables with table name contains '.', 'space' /

Posted: Sun Jul 19, 2009 1:58 pm
by jackpf
You need to use backticks ` round your column names.

Re: How to update tables with table name contains '.', 'space' /

Posted: Sun Jul 19, 2009 2:23 pm
by monindra1984
i have use backticks around the column names.. pls adivce more..

Re: How to update tables with table name contains '.', 'space' /

Posted: Sun Jul 19, 2009 6:01 pm
by Darhazer
Isn't it the same code/questions as this one:
viewtopic.php?f=1&t=103354