jeff5656 Posted October 8, 2008 Share Posted October 8, 2008 I want to change all records to have a signoff_status of "s". Then I want to change one record with a particular id to "a". However, I get an error with the following code: Any ideas? <?php require('secure.php'); include "connectdb.php"; $sql = "UPDATE staff SET signoff_status = 's'"; if (isset($sql) && !empty($sql)) { echo "<!--" . $sql . "-->"; $result = mysql_query($sql) or die ("Invalid query: " . mysql_error()); $sql = "UPDATE staff SET signoff_status = 'a' WHERE id_incr = '" . $_GET['id'] . "'"; if (isset($sql) && !empty($sql)) { echo "<!--" . $sql . "-->"; $result = mysql_query($sql) or die ("Invalid query: " . mysql_error()); ?> <p> Done <?php } header("Location: newstaff.php"); ?> Link to comment https://forums.phpfreaks.com/topic/127606-solved-parse-error-syntax-error-unexpected-end-in-line-35/ Share on other sites More sharing options...
F1Fan Posted October 8, 2008 Share Posted October 8, 2008 You're missing a }. Link to comment https://forums.phpfreaks.com/topic/127606-solved-parse-error-syntax-error-unexpected-end-in-line-35/#findComment-660236 Share on other sites More sharing options...
jeff5656 Posted October 8, 2008 Author Share Posted October 8, 2008 Thanks!! Link to comment https://forums.phpfreaks.com/topic/127606-solved-parse-error-syntax-error-unexpected-end-in-line-35/#findComment-660237 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.