Re: [ubuntu-uk] [OT] MySQL Help Required

2009-10-08 Thread Sean Miller
On Thu, Oct 8, 2009 at 6:57 PM, James Westby wrote: > In a similar vein I think that one day all online communication > will consist of people typing the number of the xkcd that is most > appropriate to the situation. > > In this particular case it would be 327. Yes, indeed... that's rather an am

Re: [ubuntu-uk] [OT] MySQL Help Required

2009-10-08 Thread James Westby
A journalist once went to stay at a monastery. On the first evening he joined them for dinner. The meal started in silence. As the plates from the starter were being cleared, a young monk shouted out "Eighty-four" and everyone rolled around laughing. The journalist was confused, but just smiled pol

Re: [ubuntu-uk] [OT] MySQL Help Required

2009-10-08 Thread Stephen Garton
Sean, That's great. Don't know why I didn't think to do it in the php in the first place, so thanks. Steve On Oct 8, 2009 6:27 PM, "Sean Miller" wrote: On Thu, Oct 8, 2009 at 6:21 PM, Sean Miller wrote: > $dt = date("y-m-d",s... that will need, I think, to have another strtotime... ie...

Re: [ubuntu-uk] [OT] MySQL Help Required

2009-10-08 Thread Sean Miller
On Thu, Oct 8, 2009 at 6:21 PM, Sean Miller wrote: >      $dt = date("y-m-d",strtotime("+1 days",$dt)); that will need, I think, to have another strtotime... ie... $dt = date("y-m-d",strtotime("+1 days",strtotime($dt))); Apologies. Sean -- ubuntu-uk@lists.ubuntu.com https://lists.ubunt

Re: [ubuntu-uk] [OT] MySQL Help Required

2009-10-08 Thread Sean Miller
Surely the key is to dynamically build your SQL statement in the PHP? In other words supply start date and supply end date. Then you start your SQL as... $query = "SELECT User as name"; ...then loop through the dates between start/end dates (putting date as var $dt), writing a line for each...

[ubuntu-uk] [OT] MySQL Help Required

2009-10-08 Thread Stephen Garton
Apologies for cross posting on both the planet and the mailing list, but I could really do with some help on MySQL if there are any experts out there! In an effort to reduce the cross-posting noise, I'll just point in the direction of my blog post: http://www.sheepeatingtaz.co.uk/blog/2009/10/08/m