EagleAmerican Posted August 6, 2007 Share Posted August 6, 2007 Hi again, I am just full of questions.. but heh.. no question is the only stupid question, right? Anyways, using something like this, $sql = mysql_query("SELECT name,note,id FROM notes") or die(mysql_error()); How could I get the last 10 entries into the database? I was thinking the 10 highest ID's but I couldn't think of a way to do that. Thanks, Adam Quote Link to comment https://forums.phpfreaks.com/topic/63480-solved-last-10/ Share on other sites More sharing options...
teng84 Posted August 6, 2007 Share Posted August 6, 2007 $sql = mysql_query("SELECT name,note,id FROM notes order by id desc limit 10") Quote Link to comment https://forums.phpfreaks.com/topic/63480-solved-last-10/#findComment-316418 Share on other sites More sharing options...
EagleAmerican Posted August 6, 2007 Author Share Posted August 6, 2007 Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/63480-solved-last-10/#findComment-316426 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.