jd2007 Posted July 21, 2007 Share Posted July 21, 2007 how do i select the last field of a mysql table ? Quote Link to comment 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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.