Anybody can see what's wrong here?
The problem arise when I put the WHERE in the UPDATE statement.
The licencia field already exists and doesnt change in the update.
I get the no update error.
Thanks a lot.
$dbhost = "localhost";
$dbuser = "sitio2";
$dbpass = "xxxxxx";
$dbname = "sitio2";
$db = mysql_connect($dbhost,$dbuser,$dbpass) or die ("no conecto");
mysql_select_db("$dbname",$db) or die("no selecciona db");
$result = mysql_query("UPDATE antecedentes WHERE licencia='$licencia' SET linea='$linea', nombre='$nombre', apellido='$apellido', licencia='$licencia', co1='$co1', co2='$co2', co3='$co3', co4='$co4', co5='$co5', co6='$co6', co7='$co7', co8='$co8', co9='$co9', co10='$co10', co11='$co11', co12='$co12', co13='$co13' ")or die("no update");
The problem arise when I put the WHERE in the UPDATE statement.
The licencia field already exists and doesnt change in the update.
I get the no update error.
Thanks a lot.
$dbhost = "localhost";
$dbuser = "sitio2";
$dbpass = "xxxxxx";
$dbname = "sitio2";
$db = mysql_connect($dbhost,$dbuser,$dbpass) or die ("no conecto");
mysql_select_db("$dbname",$db) or die("no selecciona db");
$result = mysql_query("UPDATE antecedentes WHERE licencia='$licencia' SET linea='$linea', nombre='$nombre', apellido='$apellido', licencia='$licencia', co1='$co1', co2='$co2', co3='$co3', co4='$co4', co5='$co5', co6='$co6', co7='$co7', co8='$co8', co9='$co9', co10='$co10', co11='$co11', co12='$co12', co13='$co13' ")or die("no update");