Here's the situation: I have an iframe which has only a one sentence text with a hyperlink, like so: You are signed IN or You are signed OUT You are signed (is the static text) IN or OUT (is the dynamic hyperlink) -- this will toogle when the user click on it. These toggle states allow the user to sign in or out and it is logged into a database I have an MySQL database with a table called: tblUsers This table has a field called: bolCurrentStatus which holds a value of either 0 or 1. 0=out 1=in I track the user by their IP address (its an Intranet site and everyone has a static IP and they are permitted to log on only from their machine.) This is what the code looks like: ip = [login to view URL]("REMOTE_ADDR") UserStatus = objRS("bolCurrentStatus") ' from a recorderset If UserStatus = 0 Then sqlUpdate = "UPDATE tblUsers SET bolCurrentStatus = 1" Else sqlUpdate = "UPDATE tblUsers SET bolCurrentStatus = 0" End If See the attachment for all the code
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows 2000 sp3 IE 6 (only)