Hi programmers in the house. I want to display results out of database using pagination because it's is showing all the 100 results at once. I would be happy if a source code can be given out. I want PHP language. Thanks

U didnt even bother 2 say d language u want d code in or even paste ur cold let c hw fa u have gone, i now see y d programming section is dieing slowly. Are u sure u wrote or even configured d first code urself at all?

^^^ cant u see its PHP he mentioned ?

@ OP , kindly try the following :

http://www.phpfreaks.com/tutorial/basic-pagination

http://www.phpeasystep.com/phptu/29.html

http://forum.codecall.net/topic/50803-simple-pagination/

best

My contribution to you. take a look at the function below and hopefully it should help

/*function taking arguments for databse table, 
number of results you wish to display set to a default of 10 and 
the current page you are viewing*/
function pagination($table, $num_of_results = 10, $current_page = 1){ 
    /*connection string.*/
    /*dont forget to enter the appropriate login credentials and database name.*/
    $connect = mysql_connect(localhost, dba_username, dba_password);
	$db = mysql_select_db(db_name, $connect);
	
	/*check to see if the page id is set in the url*/
	$current_page = (isset($_GET['pid'])) ? $_GET['pid'] : 1; 
	
	/*setting url for controls so you dont have to bother about the current url in using the function*/
	$page_url = $_SERVER['REQUEST_URI'];
	$page_url = explode("?", $page_url);
	$page_url = $page_url[0];
	
    /*querry to count all results*/
    $sql = "select id from ".$table;
    $query = mysql_query($sql);
    $total_result_count = mysql_num_rows($query);
    
    /*offset being what number the querry results should begin from to count the set number of results*/
    $offset = ($current_page - 1)*$num_of_results;

    /*querry to return desired results*/
    $sql = "select * from $table limit $offset, $num_of_results";
    $query = mysql_query($sql);
	
	/*page controls*/
	$p = 1;
	$page_num = ceil($total_result_count/$num_of_results); //returns a rounded up value for number of expected pages
	if(isset($_GET['pid']) and $_GET['pid'] != 1){
		$page_ctrl = "<a href='".$page_url."?pid=".($_GET['pid'] - 1)."'>Previous</a> | ";
	} else {
		$page_ctrl = "Previous | ";
	}
	while($p <= $page_num){
		$page_ctrl .= "<a href='".$page_url."?pid=".$p."'>".$p."</a>| ";
		$p++;
	}
	if(isset($_GET['pid']) and $_GET['pid'] != $page_num){
		$page_ctrl .= "<a href='".$page_url."?pid=".($_GET['pid'] + 1)."'>Next</a> ";
	} else {
		$page_ctrl .= "Next ";
	}
	echo $page_ctrl;
	
	
    /*begin results table*/
    echo "<table id='paginated'>"; //usually smart to give the table an id so you can style it later
    echo "<tr><thead><tr><th>SN</th><th>ID</th><th>Other Columns</th></tr></thead></tr>";

    $i = ($offset + 1);
    while($result = mysql_fetch_assoc($query)){
        /*dont forget to use the appropriate table names*/
        echo "<tr><td>".$i."</td><td>{$result['id']}</td><td>{$result['subject']}</td></tr>"; 
        $i++;
    }
    echo "</table>";
    
    echo $page_ctrl;
    
    mysql_close();
}



/*to test simply run the function as below replacing the argument with a valid table name*/
pagination("table_name";

Can be solved here. use the ask question link
http:
http://trimer247.org