jd2007 Posted July 21, 2007 Share Posted July 21, 2007 how do i select the last field of a mysql table ? Link to comment https://forums.phpfreaks.com/topic/61103-how-do-i-select-the-last-field-of-a-mysql-table/ Share on other sites More sharing options...
AndyB Posted July 21, 2007 Share Posted July 21, 2007 I assume you mean 'last' record. If so, the answer is "it depends". Highest auto-increment id, latest date, etc. The key is your query where you should SELECT ... FROM tablename WHERE {optional condition} ORDER by [some_field_name} DESC LIMIT 1 Link to comment https://forums.phpfreaks.com/topic/61103-how-do-i-select-the-last-field-of-a-mysql-table/#findComment-304078 Share on other sites More sharing options...
DeadEvil Posted July 21, 2007 Share Posted July 21, 2007 #count row $query = mysql_query("Select count(field_name) from tbl_name"); $row = mysql_num_rows($query); #get last field $query = mysql_query("Select field_name from tbl_name LIMIT '$row' , 1"); $row = mysql_num_rows($query); I dont know if it right... hahaha Link to comment https://forums.phpfreaks.com/topic/61103-how-do-i-select-the-last-field-of-a-mysql-table/#findComment-304089 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.