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 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 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!!! 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
Archived
This topic is now archived and is closed to further replies.