Right, a couple of things i'd like a little advice on.
Firstly, I'm doing a subscription based login system. When the user signs up, they get 365 days credit. Was is the best method of removing 1 credit off everyday on 100's of users. The data is stored in a mysql db.
Secondly, I'll be having a directory/categorys (like how ebay has). Whats the best way to about this?
Many thanks.
Nathan
Categorys & Date functions
Moderator: General Moderators
Categorys & Date functions
Last edited by nabberuk on Mon Sep 03, 2007 11:21 am, edited 1 time in total.
Re: a little advice
You yould store the expiration date instead of the amount of credits.nabberuk wrote: When the user signs up, they get 365 days credit. Was is the best method of removing 1 credit off everyday on 100's of users.
Re: a little advice
Would i be able to work out how many days are left?volka wrote:You yould store the expiration date instead of the amount of credits.nabberuk wrote: When the user signs up, they get 365 days credit. Was is the best method of removing 1 credit off everyday on 100's of users.
when using the datediff function i get the following;califdon wrote:Datediff()
Code: Select all
Fatal error: Call to undefined function datediff() in C:\xampp\htdocs\datetest.php on line 5EDIT: is datediff a mysql or php function? agh, im confused.
Many thanks.