changing vaules in tables

iochinome

hey guys, i need to be able to change a specific value in a table: there are three values in a row in this table, NAME, PASSWORD, and BOOLY. i want to be able to toggle BOOLY for when the person is logged on or not, so change that value to 0 when they are not logged on, and 1 when they are. i have all the rest of the code done, just this part is stumping me. i tried fetching the array of this row and saying "$result['BOOLY'] = "1" " and so forth, but that didnt change it in the database for some reason. thnaks guys

iochinome

does nobody know or is this impossible and no one wants to tell me? thx

Monie

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...

__________________