I have a table that holds peoples profiles in it. It has several columns one in which is named "lastlogin". When the member logs into the site, I want it to insert the date and time that they logged in.
I thought that the following would work, but it does not, so I even tried to make the $Query2 a global since it was in an IF statement thinking I was having a Variable Scope Problem, but that did not work either.
Here is the chunk of code I am dealing with, can anyone tell me what is wrong?
if ($enterpass === "$veripass" && ($enteruser === "$veriuser")) {
$Query2 = "UPDATE $TableName1 set lastlogin=NOW() WHERE member_id='$veri_ID'";
session_start();
session_register ('uu');
session_register ('auth');
session_register ('status');
session_register ('ID');
session_register ('zone');
session_register ('rep');
$uu = "$sessUSER";
$auth = "$sessAUTH";
$status = "$sessSTATUS";
$ID = "$veri_ID";
$zone = "$sessZONE";
$rep = "$sessrep";
print("
<head>
<title>ENTRANCE</title>
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>
</head>
.......and it continues to print the entrance page.
