MYSQL Update

[Anon]

I am having major problems trying to perform an update with the code listed below. When the timer in my web page completes its cycle, I get the following error -- THERE IS A SQL SYNTAX ERROR AT 'SET flagg =YES WHERE idtrans='$idtrans'. Can anyone help!!!

On my Dell server, I have install PHP 4.1.1, Apache 3.20.X, and RedHat 7.1 with patches.

$query = "SELECT idtrans, page FROM $alert WHERE date=CURDATE() AND (DATE_SUB(registerdate, INTERVAL '2:30' MINUTE_SECOND) <= DATE_ADD(NOW(), INTERVAL '0;0')) AND flagg !='YES'";

$updateAl = "UPDATE $alert SET flagg='YES' WHERE idtrans='$idtrans';

if (!($link=mysql_connect($hostname, $databaseName, $password))) {
printf("Error: %d %s", mysql_errno($link), mysql_error($link));
exit();
}

if (!mysql_select_db($databaseName,$link)) {
printf("Error: %d %s", mysql_errno($link),mysql_error($link));
exit();
}

$result=mysql_query($query);
$num_rows=mysql_num_rows($result);

if ($num_rows) {
while(($rows=mysql_fetch_object))) {
$idtrans=$row->idtrans;
$page=$row->page;

// function opens a new alert window
alertWindow($idtrans,$page);

if (!mysql_query($updateA1,$link)){
prinft("Error: %d %s", mysql_errno($link),mysql_error($link));
}

mysql_free_result($result);
}

[Anon]

In your example you have first $updateAl with an L as the last caracter, and then you use $updateA1, with a number one. If you copied and pasted this code that might be the problem, since:

$updateAl = "UPDATE $alert SET flagg='YES' WHERE idtrans='$idtrans';

looks fine to me.