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:neil@xxxxxxxxxxx] > Sent: 25 January 2005 03:12 > To: php-db@xxxxxxxxxxxxx > Subject: 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
