how do i split my mysql result into several pages?.

It's called Pagination. There are several good tutorials out there, try Google.

@Craze: Why post if you're not going to be helpful?

@andyp: This should get you started:

PHP Code:

<?php
// Assume $database is an instance of class mysqli ( http://us2.php.net/manual/en/function.mysqli-connect.php )

define('RESULTS_PER_PAGE',25);

//Make sure query has SQL_CALC_FOUND_ROWS
$query_string = "SELECT SQL_CALC_FOUND_ROWS * FROM my_table WHERE ...";

//Initialize variables
$page = 1;
$total_rows = 0;
$num_pages = 0;

if (isset($_GET['page'])) {
  $page = $_GET['page'];
}
if ($page == 0) {
  $page = 1;
}

//Limit total number of results
$query_string .= " LIMIT ".(($page-1) * RESULTS_PER_PAGE).",".RESULTS_PER_PAGE;

if ($query_results = $database->query($query_string)) {
  if ($query_results->num_rows > 0) {
    //Find page count information
    if ($row_count_query = $database->query("SELECT FOUND_ROWS() AS total_rows")) {
      if ($row_count_query->num_rows > 0) {
        $row_count = $row_count_query->fetchObject();
        
        $total_rows = $row_count_query->total_rows;
        
        $num_pages = ceil ($total_rows/RESULTS_PER_PAGE);
      }
    }
    //Fetch query results
    while ($a_result = $query_results->fetchObject()) {
      print_r($a_result); //Obviously, you need to customize this.
    }
    //Echo out pagination
    if ($num_pages > 1) {
      echo '<form method="get">';
      echo '<select name="page" onChange="this.form.submit();">';
      for ($page_number=1;$page_number<=$num_pages;$page_number++) {
        echo '<option value="'.$page_number.'"'.(($page_number==$page)?' selected="selected"':'').'>'.$page_number.'</option>';
      }
      echo '</select>';
      echo '</form>';
    }
  }
}
?>

Thanks for that