[PHP] [php] most recent row from table

2009-06-02 Thread HELP!
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

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

2009-06-02 Thread Bastien Koert
On Tue, Jun 2, 2009 at 11:49 AM, HELP! izod...@gmail.com 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

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 with

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! izod...@gmail.com 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

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 pa...@quillandmouse.com wrote: On Tue, Jun 02, 2009 at 11:58:07AM -0400, Bastien Koert wrote: On Tue, Jun 2, 2009 at 11:49 AM, HELP! izod...@gmail.com wrote: Hi, how do you select the most recent row from sql table if the date are stored

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 pa...@quillandmouse.com 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

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 pa...@quillandmouse.com 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