Entonces lo dejo NULL???
mi code quedo asi
Código PHP:
//
$sql="update $tblrequests set categoryid='$categoryid', ";
$sql.="severity='$severity',";
$sql.="estimatedtime='$estimatedtime',";
$sql.="status='$status',";
$sql.="technicianid='$technicianid',";
$sql.="emailupdate='$emailupdate',";
$sql.="releasecall='$releasecall',";
$sql.="resolution='$resolution',";
$sql.="status2='$status2',";
$sql.="op1='$op1',";
$sql.="op2='$op2',";
$sql.="op3='$op3',";
$sql.="op4='$op4',";
$sql.="op5='$op5',";
$sql.="op6='$op6',";
$sql.="op7='$op7',";
$sql.="op8='$op8',";
$sql.="op9='$op9',";
$sql.="op10='$op10',";
$sql.="nrequest='$nrequest',";
$sql.="sorder='$sorder',";
$sql.="nrfqm='$nrfqmm',";
$sql.="pdtc='$pdtc',";
$sql.="postc='$postc',";
$sql.="nfactura='$nfactura' ";
$sql.="where ticketnumber='$ticketnumber'";
$result=mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
//actualizando las fechas
$sql="update $tblrequests set fop2=now() where fop2 is null and ticketnumber='$ticketnumber'";
if($op2=="1") mysql_query($sql);
$sql="update $tblrequests set fop3=now() where fop3 is null and ticketnumber='$ticketnumber'";
if($op3=="1") mysql_query($sql);
$sql="update $tblrequests set fop4=now() where fop4 is null and ticketnumber='$ticketnumber'";
if($op4=="1") mysql_query($sql);
$sql="update $tblrequests set fop5=now() where fop5 is null and ticketnumber='$ticketnumber'";
if($op5=="1") mysql_query($sql);
$sql="update $tblrequests set fop6=now() where fop6 is null and ticketnumber='$ticketnumber'";
if($op6=="1") mysql_query($sql);
$sql="update $tblrequests set fop7=now() where fop7 is null and ticketnumber='$ticketnumber'";
if($op7=="1") mysql_query($sql);
$sql="update $tblrequests set fop8=now() where fop8 is null and ticketnumber='$ticketnumber'";
if($op8=="1") mysql_query($sql);
$sql="update $tblrequests set fop9=now() where fop9 is null and ticketnumber='$ticketnumber'";
if($op9=="1") mysql_query($sql);
$sql="update $tblrequests set fop10=now() where fop10 is null and ticketnumber='$ticketnumber'";
if($op10=="1") mysql_query($sql);
$sql="update $tblrequests set fop1=now() where fop1 is null and ticketnumber='$ticketnumber'";
if($op1=="1") mysql_query($sql);
Y no me hace ninguna actualizacion en la base de datos man .........................