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 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") 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. Link to comment https://forums.phpfreaks.com/topic/63480-solved-last-10/#findComment-316426 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.