$updateSQL = sprintf("UPDATE client SET Raison_sociale=%s, Adresse=%s, telephone=%s, Gestionnaire=%s, Activite=%s WHERE NumCli=%s",
GetSQLValueString(strtoupper(addslashes($HTTP_POST_VARS['raison'])), "text"),
GetSQLValueString($HTTP_POST_VARS['adresse'], "text"),
GetSQLValueString($HTTP_POST_VARS['telephone'], "text"),
GetSQLValueString($HTTP_POST_VARS['gestionnaire'], "text"),
GetSQLValueString($HTTP_POST_VARS['activite'], "text"),
GetSQLValueString($HTTP_POST_VARS['NumCli'], "int"));
mysql_select_db($database_connection, $connection);
$Result1 = mysql_query($updateSQL, $connection) or die(mysql_error());
Partager