Re: [PHP] If date is greater than

On Sun, 2013-10-20 at 00:00 -0400, Bastien wrote: > > Thanks, > > Bastien > > > On Oct 19, 2013, at 10:44 PM, John Taylor-Johnston > > wrote: > > > > I have date strings in my mysql db. -mm-dd. > > I want to parse to see if the date is greater than november 2011 and less > > than decemb

Re: [PHP] Algorithm Help

Hi, Indeed making and maintaining the graph looks like the best approach here to tackle this problem , but what does not seem clear to me is this -- "Suppose a family can host 5 children , then you need to find the set of 5 such nodes out of the total no. of nodes(assume 10) such that the total we

Re: [PHP] Algorithm Help

You don't need to maintain the history of which kids stay where unless you want to for other reasons. You just need to find the children that have staid the least amount of time together, which this approach would do for you. So, when 4 children stay together you say 1 together with 2 1 together w

Re: [PHP] If date is greater than

On Oct 20, 2013, at 4:01 AM, Ashley Sheridan wrote: > Yes, I was going to ask, why are you storing your dates as strings? > MySQL has a perfectly good DATE type. It's also generally faster > comparing dates within a MySQL query than PHP code. > > Thanks, > Ash > http://www.ashleysheridan.co.uk