hi using mysql as you describe is probably the most elegant and efficient way to do it
is there a reason for asking php to do it? Peter > -----Original Message----- > From: neil [mailto:[EMAIL PROTECTED] > Sent: 25 January 2005 03:12 > To: php-db@lists.php.net > Subject: [PHP-DB] last record > > > Apart from the obvious of reversing the sort order in a select > statement and > then picking off the first record > > eg. select * from blah where somefield like '%something%' order by > someotherfield desc limit 0,1 > > is there any way in php rather than sql to pick the last record > in a record > set? > > Thanks > > Neil > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
