Rewinding the result for reuse

…If you attempt to loop through the results of a select query…a second time, it won’t work unless you reset the result object.…Doing so is trivially easy in MySQL.…This is mysqli__reuse.php which you can find in the…Chapter 5, 05_05 folder of the exercise files.…The try block at the top of the page submits…a select query, and then stores the result set as result.…In the body of the page, the while loop on lines 24 to 26 uses…the fetch_assoc method to display an ordered list of links.…

Further down, on lines 30 to 33, a second while loop…attempts to use the same result object to display a definition list.…So, if we load this into a browser, we can see what happens.…The first list is displayed but the definition list isn't.…This is because a result set uses an…internal pointer to keep track of the next row.…Displaying the first list puts the pointer at the end of the results set, so before…trying to use the results again, we need to move the pointer back to the beginning.…If you watched the first half of this course,…