on 14/11/02 8:20 AM, vernon ([EMAIL PROTECTED]) wrote: > 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"); > ?>
Try adding the line echo mysql_error(); after the line $result = mysql_query($myquery, $connPENPALS); This should tell you if you have a mysql error... if not, then we can look at other things.. Justin French -------------------- Creative Director http://Indent.com.au Web Developent & Graphic Design -------------------- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php