₦airaland Forum

Quite impressive, dude earns $74 a month, saves $28 after spending $46 meaning she lives on $1.53 a day. And he/she doesn't tithe, nor does he/she give offerings [I am assuming he/she is Christian]... BTW by UN definition, he/she is living in extreme poverty. No analysis just stating the facts of the statement. My unbiased, unprejudiced POV.

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";

I keep thinking to myself: what ever happened to Samson Siasia? Now we have a world class shoe shiner! Sia One took the Nigerian boys to the finals in 1995 and lost to the Argrntines in the finals, took the remnant of that team to the finals of the subsequent olympics and lost in the finals to the same Argentina, now Batista and Sia One are outta contention for the world cup but Chile was smart enough to take a coach who almost stole the number one spot for south america in the world cup qualifiers.

Look out for Chile in the world cup,

na true oh! after liverpool win lig this season we go get fans everywhere like arsenal man u and chelsea. the one dat beats me is where all em chelsea fans came from folks who never heard of torre andre flo!

no need to decamp. i recall wen i started supportin liverpool, men the yabis wey follow me eh! it was not easy, then came th 2005 champions lig finals, calls and txt mesages nearly kill me, how ac milan go carry liverpool scrub ground, and my fone rang some more after the 1st half!

but man i had the last brag that day. lig hust start and personally if u ask me to predict i still think man u will finish second after liverpool!

check out the www.calabaronline.com poll on who will posibly win the premiership this season. and vote too!

well its bin eons since we last won a lig title! i saw a team i thot was the complete team play last season 4 liverpool and now it seems even more complete i hope it can b the first time inalong time dat we win the lig. wot do u think our chances r?

Liverpool FC was almost complete last season just there was a problem upfront,  the keeper the envy of the world the man stops penalties better than dudek! knows how to go 4 that ball an all. the back 4 carrager (fantastic), Risse (wow!), finan (the unsung hero), Agger (the boy to watch) and possibly G. Heinze from man u; now heres my fun part the midfield i dare say the best in europe! Alonso-Gerrard, Sissoko-maccerano, kewel-pennant, lucal(the nu kid!), the problem anyone would have identified with such a stingy defence and a great midfield causin a fantastic home record would be the lack of a 20goals a season striker.

Enter Torrez! the 18-19 goals a season striker from Athletico madrid who had to play infromt of a mediocre midfield, what does all this spell? the firt treble in a series for LFC!!!

We never walk alone!