tengo este update:
if ($HTTP_POST_VARS['change']!=""){
$query=" update Comercials set "
." cTitle='".$title."'"
." wname='".$wname."'"
." ,lifeEstile=".$le
." ,turism=".$tu
." ,Surfing=".$su
." ,realEstate=".$re
." ,loadging=".$lo
." ,ecology=".$eco
." ,rest=".$res
." ,other=".$ot
." ,cEmail='".$email."'"
." ,email2='".$email2."'"
." ,cPhone='".$phone."'"
." ,phone2='".$phone2."'"
." ,phone3='".$phone3."'"
." ,site='".$site."'"
." ,link='".$link."'"
." ,description='".$Description."'"
." ,bdescr='".$bdescr."'"
." ,testim='".$testim."'"
." ,services='".$serv."'"
." where cid =".$cid;
$result = mysql_query($query);
if ($result){
echo "<script>document.location.href='/php/menu.php?m=c&cid=".$cid."'</script>";
}else{
/**echo " <script>document.location.href='/php/error.php?err=0'</script>";**/
echo $query;
}
} // change
si doy clik en change me hace el update pero me manda para la pagina de error, no se por ke.
imprimo el update y está bien:
update Comercials set cTitle='casa2' wname='askjklj' ,lifeEstile=1 ,turism=0 ,Surfing=1 ,realEstate=0 ,loadging=0 ,ecology=0 ,rest=0 ,other=0 ,cEmail='kl' ,email2='jklj' ,cPhone='klj' ,phone2='lkj' ,phone3='klj' ,site='lkj' ,link='klj' ,description=' kljklj' ,bdescr='jkl' ,testim='jkl' ,services='jkjk' where cid =13
alguna idea???
que reviso??
gracias!