View Single Post
  #3 (permalink)  
Old Mar 18th, 2008, 11:53
Monie Monie is online now
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,608
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
Send a message via Yahoo to Monie
Re: changing vaules in tables

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

Last edited by Monie; Mar 18th, 2008 at 11:59.
Reply With Quote