sql syntax problem

[woodplease]

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

 

[mikosiko]

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

[woodplease]

thanks