[Wolves] mysql select help

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


On 08/03/12 12:02, Wayne Morris wrote:
> Hi,
> Got a working database with list of items and the date(s) on which 
> they occur.
> Already set up so I can search a particular date and display all the 
> records.
>
> trying to find a way to 'display all the records that occur on the 
> next date when something happens'
> and ignore all the stuff on days thereafter.
> So I can have a button that on click displays '6 items on Friday 30th'
>
> been scratching my head all morning, any ideas?
>
> Cheers
>
> _______________________________________________
> Wolves LUG mailing list
> Homepage: http://www.wolveslug.org.uk/
> Mailing list: Wolves at mailman.lug.org.uk
> Mailing list home: https://mailman.lug.org.uk/mailman/listinfo/wolves
If the field is a timestamp you can say something like:

select * from mydb where timestamp >= now();

or:

select * from mydb where timestamp >= ref_date;

Or did I misunderstand your query?

-- 
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