[tcooper]

Why won't this update my database?

if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE POJOBDETAIL SET POJSKILLS=%s, POJPROJTEAM=%s, POJSUBNAME=%s, POJSUBSKILL=%s, POJDELIV=%s, POJMILE=%s, POJCOMM=%s WHERE POJJOBNO=%s",
GetSQLValueString($HTTP_POST_VARS['txtSkills'], "text"),
GetSQLValueString($HTTP_POST_VARS['txtProjTeam'], "text"),
GetSQLValueString($HTTP_POST_VARS['txtSubName'], "text"),
GetSQLValueString($HTTP_POST_VARS['txtSubSkills'], "text"),
GetSQLValueString($HTTP_POST_VARS['txtDeliver'], "text"),
GetSQLValueString($HTTP_POST_VARS['txtMilestone'], "text"),
GetSQLValueString($HTTP_POST_VARS['txtComments'], "text"),
GetSQLValueString($HTTP_POST_VARS['txtselectJobNo'], "text"));

mysql_select_db($database_Thor, $Thor);
$Result1 = mysql_query($updateSQL, $Thor) or die(mysql_error());
}


As a check if have done this
<?php
if ((isset($HTTP_POST_VARS["MM_update"]))
$ckupdate=1;
else $ckupdate=2;
echo $ckupdate ?>

This returns a value of 1 so I know MM_udpate is set.

[darkcarnival]

well sprintf doesnt belong where it is try placing mysql_query or mysql_db_query there and it should work