Jump to content


Photo

deleting user id from DB


  • Please log in to reply
1 reply to this topic

#1 xtiancjs

xtiancjs
  • Members
  • PipPipPip
  • Advanced Member
  • 47 posts

Posted 31 July 2005 - 10:22 PM

HI, am having some major trouble with this one.
I have set up a user login system. The user id # is stored in a mysql DB.
So far so good. The user has been given a "one use only" user #.
When the user logs out, I want to be able to delete that particular users id # from the DB.

This I have failed to do. Please help!!

#2 jeremywesselman

jeremywesselman
  • Members
  • PipPipPip
  • Advanced Member
  • 154 posts
  • LocationIndependence, KY

Posted 01 August 2005 - 04:42 AM

Well, on your logout page or in your logout function, just have a query to delete the current userid.

Here is the sql syntax you would use to delete the user

"DELETE FROM table WHERE userid = user_id"

Jeremy




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users