Genesis
-
Posts
7 -
Joined
-
Last visited
Never
Genesis's Achievements
Newbie (1/5)
0
Reputation
-
Err, hmm. actually, would that work if they closed the browser or navigated away?
-
awesome. For some reason I never considered using JS. Thanks a bunch
-
What I want to do is send a query to a database that will cause a user to be logged out after 15 minutes of the script being executed. When the user loads a page, it sets \"available\" to 1 in the database, for that user. Fifteen minutes later, that user\'s \"available\" field should be set to 0 AUTOMATICALLY. If the page is refreshed again before that time, the timer should be reset to 15 minutes. How might I go about doing this? Or is there another way to get this effect without having to delay the execution of a query?
-
bumparooni
-
Concatenating Integers with MySQL, or "get last 10 entr
Genesis replied to Genesis's topic in MySQL Help
LOL.. all this struggling and it\'s that easy! Thanks a bunch!! -
Hi there, For my website I have a news system that will have thousands of entries. What I would like to do is retrieve the 10 most recent entries. Is there a \"get X most recent entries based on index\" function? I do NOT know how to use indexes, or autoincrements or anything like that. I have tried and tried to understand them, but no tutorial I\'ve seen yet has explained them in such a way that I can understand. Or, back to my first question: is there a way to concatenate two integers? I do NOT want them added.. just appending one onto the other, like a string. (I know about the concat() function, but I dunno if it works with integers..) The reason I need to do this is because if I cannot figure out indexes, I will have to concatenate the date with the time and use that as one big number to determine which 10 posts were made most recently. Any help is greatly appreciated
-
What I want to do is send a query to a database that will cause a user to be logged out after 15 minutes of the script being executed. When the user loads a page, it sets \"available\" to 1 in the database, for that user. Fifteen minutes later, that user\'s \"available\" field should be set to 0 AUTOMATICALLY. If the page is refreshed again before that time, the timer should be reset to 15 minutes. How might I go about doing this? Or is there another way to get this effect without having to delay the execution of a query?