Tengo este insert:
$query = "INSERT INTO `Comercials` ( `username` ,`cid`, `cTitle` , `turism` , `lifeEstile` , `Surfing` , `realEstate`
, `loadging` , `ecology` , `other` , `cEmail` , `cPhone` , `site` , `link` , `description` , `fecha` , `bigdescr` , `services` , `testim` , `imagename` )
VALUES ("
."'".$username."',"
.$cid.","
."'".$title."',"
.$tu.","
.$le.","
.$su.","
.$re.","
.$lo.","
.$eco.","
.$ot.","
."'".$email."',"
."'".$phone."',"
."'".$site."',"
."'".$link."',"
."'".$Description."',"
."'".$fecha."',"
."'".$bigdescr."',"
."'".$serv."',"
."'".$testim."',"
."'')";
//Falta image
$result = mysql_query($query);
if ($result){
sendmail($cid);
echo "<script>document.location.href='/php/addprofile2.php?m=c&cid=".$cid."'</script>";
}else{
//echo " <script>document.location.href='/php/error.php?err=0'</script>";
echo $query;
}
} // insertar
Pero siempre me da error cero, al pedirle la consulta, me da lo siguiente:
INSERT INTO `Comercials` ( `username` ,`cid`, `cTitle` , `turism` , `lifeEstile` , `Surfing` , `realEstate` , `loadging` , `ecology` , `other` , `cEmail` , `cPhone` , `site` , `link` , `description` , `fecha` , `bigdescr` , `services` , `testim` , `imagename` ) VALUES ('walter',27,'Prueba d',1,1,1,1,1,1,1,'email','phone','link1','link2',' Brief','2003-02-6','Big','Serv','Testim','')
Me parece que veo todo bien.
Alguien puede sugerirme algo?
Gracias.
