Hi. Can you please help me. I have created a pagination, taken from David Power's Book 'PHP Solutions'. When I click the link to navigate to the second page, it appears to me that the SQL query doesn't run for the second time.

Please forgive me for the vagueness of this question. I'm new to programming. below is my code:

Code:
<?php
if(isset($_GET['search'])) {  
  // set maximum of records to be retrieved
...