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