Hi all, I would like to retrieve 5, 5 rows from mysql table using PHP...i tried using limit but it got some unexpected results...so anyone one of you help me out in this...
What do you mean by "5, 5"? Five rows and then five more? Five and a half rows? Five rows starting with the sixth? If you mean the latter (five rows starting with the 6th) then "limit 5, 5" is indeed the way to do it. What was the unexpected nature of the results you got?