help setting up a database, please

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
CZfrei
Forum Newbie
Posts: 5
Joined: Fri Jul 11, 2008 11:02 am

help setting up a database, please

Post by CZfrei »

Does anyone know how I can set up a database with users who can only log in a certain amount of times before their account expires? I would really appreciate any help or suggestions on how to do this. Thanks in advance.
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: help setting up a database, please

Post by jaoudestudios »

In the user table keep a counter and increment everytime they log in. When they log in check this value if greater than your specified limit do not let them log in. Fire back an error message
CZfrei
Forum Newbie
Posts: 5
Joined: Fri Jul 11, 2008 11:02 am

Re: help setting up a database, please

Post by CZfrei »

Thanks a lot that really helps me out.
Post Reply