log in record

[seanlyons]

I am trying to record the time and date of the last visit of a registered user.

I understand how to use the timestamp to record time when records are updated or inserted, but I think what I need is a little different.

Can I record a timestamp against a user when they log in ie a query is carried out to check their details are in a table?

[Mordecai]

I'm confused a bit. What you'd need to do is write, to a database or file, the time of the last visit. Then echo it out. It'd be replaced every time someone visits, naturally.

[OhLordy]

What you do is when you get to the piece of code that records that the person is logged in you do an update on the database table setting the timestamp attribute to NULL. This automatically sets the timestamp to the current time.
Good Luck
Rob

[seanlyons]

This is the part of the code which checks the login is correct

$query_rsLogin = sprintf("SELECT username, password, accesslevel FROM login WHERE username= '%s' AND password = '%s'", $myUsername_rsLogin,$myPassword_rsLogin);

$rsLogin = mysql_query($query_rsLogin, $portland) or die(mysql_error());

$row_rsLogin = mysql_fetch_assoc($rsLogin);

$totalRows_rsLogin = mysql_num_rows($rsLogin);

if($HTTP_POST_VARS['action']=="login"){
	if($totalRows_rsLogin==0){
		$errorMessage = "";
		mysql_free_result($rsLogin);
	} else {
		mysql_free_result($rsLogin);
		session_register("logged_on");
		$logged_on = $HTTP_POST_VARS['username'];
		session_register("access_level");
		$access_level = $row_rsLogin['accesslevel'];
		header("Location: welcome.php");
	}

Where do I add my update statement?

[OhLordy]

What's your database/table structure?

[seanlyons]

the database s called OHS, table is login, timestamp field is last

is this what you meant

[laserlight]

well, one logical place would be before header("Location: welcome.php");