cannot use while loop instead of foreach loop for pagination php mysql

How can I replace the foreach loop that displays content fetched from a table, to being display using this while loop?

code of foreach loop is here : http://pastebin.com/pWpLwVH3

the while loop code is here: http://pastebin.com/XZH6GxmW

both are simple codes but cannot figure a way to use while instead of for. Am current doing pagination and pagination code unforutnately all come in while loop to display table fields.

have been trying for long but am always ending with some sort of error. last error was

invalid argument supplied foreach() when modified the code this way: http://pastebin.com/8bJDVhS8

thanks everyone! this forum has done wonders with me!