Re: [PHP] [php] most recent row from table

2009-06-02 Thread Paul M Foster
On Tue, Jun 02, 2009 at 12:33:24PM -0400, Andrew Ballard wrote: > On Tue, Jun 2, 2009 at 12:17 PM, Paul M Foster > wrote: > > On Tue, Jun 02, 2009 at 04:49:44PM +0100, HELP! wrote: > > > >> Hi, > >> > >> how do you select the most recent row from sql table if the date are stored > >> this format

Re: [PHP] [php] most recent row from table

2009-06-02 Thread Andrew Ballard
On Tue, Jun 2, 2009 at 12:17 PM, Paul M Foster wrote: > On Tue, Jun 02, 2009 at 04:49:44PM +0100, HELP! wrote: > >> Hi, >> >> how do you select the most recent row from sql table if the date are stored >> this format  date('Y-m-d H:i:s')  e.g (2009-06-02 10:10:30) >> >> i have tried select top 1 f

Re: [PHP] [php] most recent row from table

2009-06-02 Thread Andrew Ballard
On Tue, Jun 2, 2009 at 12:19 PM, Paul M Foster wrote: > On Tue, Jun 02, 2009 at 11:58:07AM -0400, Bastien Koert wrote: > >> On Tue, Jun 2, 2009 at 11:49 AM, HELP! wrote: >> > Hi, >> > >> > how do you select the most recent row from sql table if the date are stored >> > this format  date('Y-m-d H:

Re: [PHP] [php] most recent row from table

2009-06-02 Thread Paul M Foster
On Tue, Jun 02, 2009 at 11:58:07AM -0400, Bastien Koert wrote: > On Tue, Jun 2, 2009 at 11:49 AM, HELP! wrote: > > Hi, > > > > how do you select the most recent row from sql table if the date are stored > > this format  date('Y-m-d H:i:s')  e.g (2009-06-02 10:10:30) > > > > i have tried select to

Re: [PHP] [php] most recent row from table

2009-06-02 Thread Paul M Foster
On Tue, Jun 02, 2009 at 04:49:44PM +0100, HELP! wrote: > Hi, > > how do you select the most recent row from sql table if the date are stored > this format date('Y-m-d H:i:s') e.g (2009-06-02 10:10:30) > > i have tried select top 1 from table where id = xx > any solution This is the problem wi

Re: [PHP] [php] most recent row from table

2009-06-02 Thread Bastien Koert
On Tue, Jun 2, 2009 at 11:49 AM, HELP! wrote: > Hi, > > how do you select the most recent row from sql table if the date are stored > this format  date('Y-m-d H:i:s')  e.g (2009-06-02 10:10:30) > > i have tried select top 1 from table where id = xx > any solution > -- > www.bemycandy.com > selec