Gruzin Posted October 9, 2006 Share Posted October 9, 2006 Hi guys,I am making a registration form, so I need to show last 3 members from db. Any ideas how to do that?Thanks for your time,George Link to comment https://forums.phpfreaks.com/topic/23467-solved-select-last-3-records-from-db/ Share on other sites More sharing options...
obsidian Posted October 9, 2006 Share Posted October 9, 2006 do you have a date field for the time they signed up? if so, it's as simple as ordering by that field:[code]SELECT * FROM users ORDER BY signupDate DESC LIMIT 3;[/code] Link to comment https://forums.phpfreaks.com/topic/23467-solved-select-last-3-records-from-db/#findComment-106479 Share on other sites More sharing options...
Gruzin Posted October 9, 2006 Author Share Posted October 9, 2006 Not yet, I will add date field for that, thanks for quick answer :) Link to comment https://forums.phpfreaks.com/topic/23467-solved-select-last-3-records-from-db/#findComment-106480 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.