Update Code not Working

Using DB - latest version.

I have one field in a different table I want to update during a Record Insert.

This is the code that should create the Update:

mysql_query("UPDATE teacher SET booklist = 1 WHERE teacherID = ".$_SESSION['id']);

The update does not occur. If I replace $_SESSION['id'] with the data the update works.

Echoing both the $row_teacher['teacherID'] and $SESSION['id'] on the page show that they match.

The entire page is attached.

Thanks,

Mike

try using this code instead:

$updateSQL = "UPDATE teacher SET booklist = 1 WHERE teacherID = ".$_SESSION['id']."");

    $update_CMD = mysql_query($updateSQL, $WA_connection) or die(mysql_error());

Originally Said By: Jason Byrnes

  try using this code instead:

php:

$updateSQL = "UPDATE teacher SET booklist = 1 WHERE teacherID = ".$_SESSION['id']."");

    $update_CMD = mysql_query($updateSQL, $WA_connection) or die(mysql_error());

  

Returns the following error:

  Unknown column 'ADMIN' in 'where clause'  

ADMIN is the $_SESSION['id'], and also the value in $row_teacherID. . .

ok, then the value needs to be enclosed in quotes;

$updateSQL = "UPDATE teacher SET booklist = 1 WHERE teacherID = '".$_SESSION['id']."'");

Originally Said By: Jason Byrnes

  ok, then the value needs to be enclosed in quotes;

php:

$updateSQL = "UPDATE teacher SET booklist = 1 WHERE teacherID = '".$_SESSION['id']."'");

  

Syntax error -- so many quotes, so little time. . .

what is the exact error, it should indicate a line number? and include a copy of the page.

Originally Said By: Jason Byrnes

  what is the exact error, it should indicate a line number? and include a copy of the page.  

The syntax error is flagged in DW along with a Dynamically-related files error -- attempt to run in browser gives a blank screen

Page attached. .

hmmm, i dont see a syntax error in the code.


may try using this for the $updateSQL:

$updateSQL = "UPDATE teacher SET booklist = 1 WHERE teacherID = ".GetSQLValueString($_SESSION['id'], "text")."");

Originally Said By: Jason Byrnes

  hmmm, i dont see a syntax error in the code.


may try using this for the $updateSQL:

php:

$updateSQL = "UPDATE teacher SET booklist = 1 WHERE teacherID = ".GetSQLValueString($_SESSION['id'], "text")."");

  

Okay -- fixed one problem, created another.

The following code updates the teacher table:

  $updateSQL = "UPDATE teacher SET booklist = 1 WHERE teacherID = ".GetSQLValueString($_SESSION['id'], "text");  

However the [Insert_ID] used for the redirect reports a zero ('0"), and the redirect to the Details page reports that the record has been deleted.

Mike

change the code order:

$updateSQL = "UPDATE teacher SET booklist = 1 WHERE teacherID = '".$_SESSION['id']."'");

    $update_CMD = mysql_query($updateSQL, $WA_connection) or die(mysql_error());  

  $_SESSION[$WA_sessionName] = mysql_insert_id($WA_connection);

to:

$_SESSION[$WA_sessionName] = mysql_insert_id($WA_connection);

$updateSQL = "UPDATE teacher SET booklist = 1 WHERE teacherID = '".$_SESSION['id']."'");

    $update_CMD = mysql_query($updateSQL, $WA_connection) or die(mysql_error());