You will get your answers by reading carefully the Date Time Functions in the MySQL Reference Manual.
Look at the URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Bernard On Wednesday 17 November 2004 16:40, Stuart Felenstein wrote: > While I'm figuring this needs to be addressed via my > scripting language wanted to ask here. > > Customers will buy a block of time to use my service. > Time meaning "number of days". 90, 45, 60, etc. > > Here are the fields relevant to this question: > PostStart [Date] > LenChoice [int] > DaysLeft [int] > > When they register , the current date is input > automagically into PostStart. LenChoice is chosen by > the user and is the length of days they want this > block. DaysLeft is where the calculation would be > done to hold the difference between the current date, > date posted and how many days were paid for. This is > where I'm not entirely sure what to do. I'm probably > inhaling gasoline or something but how would I get the > field to the numbers of DaysLeft ? > > i.e. DaysLeft[today]= 3, DaysLeft[tomorrow]=2..etc > > Thank you , > Stuart > > p.s. I'm on 4.0.22 , so no stored procedures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]