Crew-Portal Posted August 6, 2007 Share Posted August 6, 2007 Hi on the site I am making I would like on the homepage to welcome the Last member to register an account so it says something like "My SiteName" welcomes our newest member "Jimmy?" All my members have a Auto_increment in there ID under colum ID so how would I make it so the mySQL selcts the last ID in the list and displays the informaion in the colum Username Quote Link to comment https://forums.phpfreaks.com/topic/63481-solved-selceting-last-in-database/ Share on other sites More sharing options...
teng84 Posted August 6, 2007 Share Posted August 6, 2007 select * from table order by id desc limit 1 you will get the last member Quote Link to comment https://forums.phpfreaks.com/topic/63481-solved-selceting-last-in-database/#findComment-316416 Share on other sites More sharing options...
Crew-Portal Posted August 6, 2007 Author Share Posted August 6, 2007 Thank you! Such a Simple code lol! TOPIC SOLVED!!! Quote Link to comment https://forums.phpfreaks.com/topic/63481-solved-selceting-last-in-database/#findComment-316417 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.