Yeah this is definitely possible
Monie's Tips:
Assuming you have a
Login-Verify-Success method of doing your login page... So, in your verify page, you should have some kind of redirect the user to the main page , right? Ok, right before the redirect code, you need to execute some
sql statement that will UPDATE your 'BOOLY' field and set it to 1.
When you logging out, you will also need to execute some
sql statement that will UPDATE your 'BOOLY' field and set it to 0.
MySQL Sample Statement:
- PHP: Select all
// Your database connection here...
// TITLE: Update User Status/Info Upon Login Session
$sql = "UPDATE TableName SET BOOLY = 1 WHERE username = '$name'";
$result = mysql_query($sql, $connection) or die(mysql_error());
Let me know if you stuck!
Could you post in your verify.
php page as well as your logout.
php page?
Cheers...