[Wolves] mysql select help

Andy D'Arcy Jewell andy.jewell at sysmicro.co.uk
Thu Mar 8 13:22:34 UTC 2012


On 08/03/12 13:11, Wayne Morris wrote:
>
> The problem is I don't know the next date (it is a timestamp) and I 
> don't want the stuff AFTER the date, its basically a simple
> calendar preview - your next day with stuff to do is this date, and 
> contains these items eg
>
> Fri 9th apples, pears , bananas
> tues 16th eggs, beans
> thurs 18th turkey, ham
>
> I just want to click and get "apples etc" if I click on thurs 8th., 
> and if clicked on sat 1Oth get eggs,beans, with your first I would get 
> all (as i do with current set up),
> or i'd need to put a date in a search box (which i've also got).
>
> cheers
>
Maybe the mysql date functions can help, particularly adddate():

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_adddate

-- 
Andy D'Arcy Jewell

SysMicro Limited
Linux Support
T:  0844 9918804
M:  07961605631
E:  andy.jewell at sysmicro.co.uk
W:  www.sysmicro.co.uk




More information about the Wolves mailing list