if you are seeking for the last in autoincrement field, in your select use this: select max(field) from table; if is other, well, i dont remember :D Regards Nilson John Ryan dijo: > is there any quick way of selecting the 'last' row in a mysql table?? i > could write some messy code but id prefer an elegant solution. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > ------------------------- Joe Nilson Zegarra Galvez Sistemas Kola Real Telefax : 0051-54-256658 Movil: 0051-54-9603244 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php