Can anyone tell me what's wrong with theis code. I don't get any errors but the databse is never updated:
<?php $hostname_connPENPALS = "localhost"; $database_connPENPALS = "phpenpals"; $username_connPENPALS = "username"; $password_connPENPALS = "password"; $connPENPALS = mysql_pconnect($hostname_connPENPALS, $username_connPENPALS, $password_connPENPALS) or die(mysql_error()); $lastaccessdate = gmdate("M d, Y"); $myuserid = $HTTP_SESSION_VARS['svUserID']; mysql_select_db($database_connPENPALS, $connPENPALS); $myquery = "UPDATE penpals SET lastaccess=$lastaccessdate WHERE ID=$myuserid"; $result = mysql_query($myquery, $connPENPALS); header("Location: successfullogin.php"); ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php