$db = mysqli_connect('localhost', 'root', '', 'cdb')
                or die('Error connecting');

                if( isset($_REQUEST['page'])) {
                  $_SESSION['page'] = $_REQUEST['page'];
                }else{
                  $_SESSION['page'] = 1;
                }
                $records_per_page = 8;

                $where =  substr($where, 0, -3);

                $query = "SELECT * FROM cars
                              ".$where."";

                $result = mysqli_query($db, $query)
                  or die("Error in query: '$query'");
                $row = mysqli_fetch_assoc($result);
                $i = 0;
                $start = ($_SESSION['page'] - 1) * $records_per_page;
                $end = ($_SESSION['page']) * $records_per_page;
                while($row = mysqli_fetch_assoc($result) and $i < $end)
                {
                  $i++;
                  if( $i > $start )
                  {
                    echo'

                    <div class="result_main flip'.$i.' shadow2">

                        <div class="main_result_carname">
                            <h2><b>'.$row['make'].' '.$row['model'].'</b></h2>
                        </div>
                        <div class="main_result_carprice">
                            <h2><b>£'.$row['price'].'</b></h2>
                        </div>


                    </div>';
                  }
                }
                ?>

$row = mysqli_fetch_assoc($result);

$i = 0;

$result = mysqli_query($db, $query)
  or die("Error in query: '$query'");
$row = mysqli_fetch_assoc($result);
$i = 0;

while($row = mysqli_fetch_assoc($result) and $i < $end)