I have the following lines in my PHP doc.

 

<?php

mysql_select_db($database_TBAJobLink, $TBAJobLink);

$updateSQL = sprintf("UPDATE JL_Resumes SET DateEdited=%s, Status=%s WHERE
ResumeID=%s", $dateEdited, $status, $resumeID);

            mysql_query($updateSQL, $TBAJobLink) or die(mysql_error());

            echo 'The JL_Resumes table has been updated.';

?>

 

The three variables - $dateEdited, $status and $resumeID - are defined in
the top of the page.

 

I'm getting a return of.

 

You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near 'Updated WHERE
ResumeID=33' at line 1

 

What's up? What's wrong with my code? The first line in the page is a link
to the connections file.

 

Robb

Reply via email to