yanti Posted June 24, 2010 Share Posted June 24, 2010 hi guys..i need help in select function for viewing the newest data/rows. for example: select * from rwmessage where id = '(the newest row)' please help me with the line. Quote Link to comment Share on other sites More sharing options...
phpchamps Posted June 24, 2010 Share Posted June 24, 2010 select * from tablename order by id desc limit 1 note: id needs to be autoincrement for this query to work Quote Link to comment Share on other sites More sharing options...
yanti Posted June 24, 2010 Author Share Posted June 24, 2010 thanks for that...it worked. Quote Link to comment Share on other sites More sharing options...
phpchamps Posted June 24, 2010 Share Posted June 24, 2010 ur wlcme 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.