MDanz Posted May 2, 2011 Share Posted May 2, 2011 would this query select the 14th row? $getslide2 = mysql_query("SELECT * FROM Slides LIMIT 1,14",$this->connect); Quote Link to comment https://forums.phpfreaks.com/topic/235366-select-specific-row-from-table/ Share on other sites More sharing options...
mikosiko Posted May 2, 2011 Share Posted May 2, 2011 answer depends of your objectives.... - only the 14th row .. NO... - a groups of records that COULD include a 14th row... probably (if your table has 14 or more rows.) http://dev.mysql.com/doc/refman/5.0/en/select.html Quote Link to comment https://forums.phpfreaks.com/topic/235366-select-specific-row-from-table/#findComment-1209525 Share on other sites More sharing options...
gizmola Posted May 2, 2011 Share Posted May 2, 2011 Should be LIMIT 14,1 Quote Link to comment https://forums.phpfreaks.com/topic/235366-select-specific-row-from-table/#findComment-1209526 Share on other sites More sharing options...
gizmola Posted May 2, 2011 Share Posted May 2, 2011 Actually, I think it needs to be LIMIT 13, 1 if you literally want the 14th row. Quote Link to comment https://forums.phpfreaks.com/topic/235366-select-specific-row-from-table/#findComment-1209528 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.