need help with UPDATE

[VenusJ]

hello everyone,

For some reason, I couldn't UPDATE my mysql database, hopefully someone here could help me with this.

I have a script that will update the database with "session ID" and "user last login time" everytime when user login.

Here is how my database looks:
CREATE TABLE classmates (
.....
last_login datetime NOT NULL default '0000-00-00 00:00:00',
sessionID varchar(32) NOT NULL default '00000000000000000000000000000000',
.....
) TYPE=MyISAM;

here is my login function:

function loginCheck()
     {
//blah blah here

if ($match == 1)
    {
       global $NOW_user, $classmatename, $classmatepassword;
            session_register("classmatename");
            session_register("classmatepassword");
            session_register("NOW_user");
            session_register("classmate");


// THIS IS WHERE THE PROBLEM IS, 
$sessionID = "".session_id()."";
$login_insert = "UPDATE classmates SET last_login=now() AND sessionID=$sessionID WHERE mateid=$NOW_user";
       if (!mysql_query ($login_insert) ){die (mysql_error());}


   }
else if ($match == 0)
   {
//login form here
   }

However, my UDATE query doesnt seem to perform the task. When a user login, nothing is being insert into the database.
Can someone point me to the right direction.?

thank you sirs

[foolguitardude]

Hey, try replacing the 'AND' in the query with a comma.

Good luck.

[VenusJ]

hello,
tried that, but no luck...

will keep trying...
thanks

[jimson]

your problem is you need this -> ''

$login_insert = "UPDATE classmates SET last_login=now()
AND sessionID='$sessionID' WHERE mateid='$NOW_user'";

insert data needs to be single quote unless you call database function.

[VenusJ]

hello,
thanks.
But none of the suggestions worked. I have managed to change a lil as you can see from the following code:

     function loginCheck()
     {

 global $NOW_user, $classmatename, $classmatepassword, $sql, $result, $classmate;
 if ($NOW_user == "" AND $classmatename == "")
   {
   //DISPLAY LOGIN FORM HERE
   }
   elseif ($classmatename != "" OR $NOW_user != "")
   {
   global $NOW_user, $classmatename, $classmatepassword, $sql, $result, $classmate;
   $sql = "SELECT * FROM classmates WHERE classmate='$classmatename' AND
   classmatepass = PASSWORD('$classmatepassword') AND activated='1'";
   $result = mysql_query($sql)
   or die("Couldn't execute query.");
   $num = mysql_numrows($result);

   if ($match == 1) {

  global $NOW_user, $classmatename, $classmatepassword;
        session_register("classmatename");
        session_register("classmatepassword");
        session_register("NOW_user");
        session_register("classmate");


   $sessionID = "".session_id()."";
   //I TOOK OUT $sessionID because it didn't work
   //this query will update the last_login field only when I update some other fields in the same table
   //like say when i update classmatename from classmate.php, then last_login would update  
   mysql_query("UPDATE classmates SET last_login=now() WHERE mateid='$NOW_user'");

}
else if ($match == 0)
{
//GIVE ERROR MESSAGE AND DISPLAY FORM HERE
}



}

It seems to work only when I tried to update some other fields from the table. isn't it weird?

It would be greatly appreciated if someone knows what i did wrong.

thanks
Venus

[jimson]

$sessionID = "".session_id()."";

is equal to

$sessionID = session_id();