daydreamer Posted August 27, 2008 Share Posted August 27, 2008 Hi, I am going to use a mysql database, and on one of my pages i need to display a number. It is very important that this number stays accurate. it decease's when users use credits, and when user's top up their account it goes up! anyway, when the user logs in I will use session_start(); , use SQL to get the number from the database and store it in a $_SESSION['current']; Is it best to get that same number from the database every time, or just when they login, then update the database when they log out. Problem is if they logout without running the logout script (ie closing the browser) how will my PHP script know when to update the database? Also I want to keep the site as fast as possible, which means minimum database querys, right? Thanks! Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted August 27, 2008 Share Posted August 27, 2008 You need to grab/manipulate that number from the database each time. Going with sessions isn't going to work, and you already stated the problem, and there is no way around that. Quote Link to comment Share on other sites More sharing options...
daydreamer Posted August 27, 2008 Author Share Posted August 27, 2008 ok cheers Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.