woodplease Posted September 7, 2010 Share Posted September 7, 2010 i'm trying to update a value in my table using the UPDATE command, but i'm getting the error "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 ''bob1234' at line 1" <?php session_start(); include "includes/dbconnect.php"; forum_connect(); $b = time (); $d = date("Y-m-d",$b); $s = time (); $t = date("G:i:s",$s); $query = "UPDATE users SET last_visit_date = '$d', last_visit_time = '$t' WHERE username = '".$_SESSION['user']; $result= mysql_query($query) or die("Select Error :" . mysql_error()); header("Location: logout2.php"); ?> i've included all the code so you can see what is going on. bob1234(from the error) is the value stored in the session. Any help on this would be great Link to comment https://forums.phpfreaks.com/topic/212789-sql-syntax-problem/ Share on other sites More sharing options...
mikosiko Posted September 7, 2010 Share Posted September 7, 2010 in this line $query = "UPDATE users SET last_visit_date = '$d', last_visit_time = '$t' WHERE username = '".$_SESSION['user']; you are missing a single quote at the end should be $query = "UPDATE users SET last_visit_date = '$d', last_visit_time = '$t' WHERE username = '".$_SESSION['user'] . " ' "; // spaces only for clarity Link to comment https://forums.phpfreaks.com/topic/212789-sql-syntax-problem/#findComment-1108391 Share on other sites More sharing options...
woodplease Posted September 7, 2010 Author Share Posted September 7, 2010 thanks Link to comment https://forums.phpfreaks.com/topic/212789-sql-syntax-problem/#findComment-1108437 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.