Login then Update table

[[deleted]]

I want to be able to check when a user last logged in. A user authenticates against a database to enter the site.

As I see it, there are two steps: 1. A SELECT statement is processed to validate user, 2. the table tblusers is updated reflect the last successful login.

The first part is done, but I'm not sure how to process an UPDATE statement and a SELECT statement at the same time (ie. when the LOGIN button is clicked).

I'm using PHP 4.22 and MySQL.

Thanks.

[sgoku01]

huh?? You tried to put them in the same script? Cause that has to work..
Try:

$query_1 = mysql_query("SELECT user FROM users WHERE user = '" . $user . "'");
$result_1 = mysql_result($query_1);
$row_1 = mysql_fetch_array($result_1);

$query_2 = mysql_query("UPDATE user SET last_login='" . $time . "' WHERE user = '" . $user . "");
$result_2 = mysql_fetch_row($query_2);

Is this what you mean?