CodingForums.com - Limit MySQL result per page

Hi... I need some help over here... attached is my coding that will display all the result in a single page. I need to limit the result let say to 50 results per page. Anybody can help me out here? Million thanks in advance... :thumbsup:

Code:

<?php

// Make a MySQL Connection

mysql_connect("localhost", "root", "") or die(mysql_error());

mysql_select_db("dbase") or die(mysql_error());



// Get all the data from the "defaulter" table

$result = mysql_query("SELECT * FROM `defaulter` WHERE `NamaMajikan` IS NOT NULL") 

or die(mysql_error());  



echo "<center>&nbsp;<br>";

echo "<table border='1' cellspacing='1' cellpadding='0'>";

echo "<tr> <th rowspan='2'>&nbsp;Kod Majikan&nbsp;</th> <th rowspan='2'>Nama Majikan</th> <th colspan='5'>Bilangan Bulanan</th> <th colspan='5'>Anggaran Amaun Tertunggak</th> <th rowspan='2'>&nbsp;Jumlah Besar&nbsp;</th></tr>";

echo "<tr><th>&nbsp;2007&nbsp;</th> <th>&nbsp;2008&nbsp;</th> <th>&nbsp;2009&nbsp;</th> <th>&nbsp;2010&nbsp;</th> <th>&nbsp;2011&nbsp;</th><th>&nbsp;2007&nbsp;</th> <th>&nbsp;2008&nbsp;</th> <th>&nbsp;2009&nbsp;</th> <th>&nbsp;2010</th> <th>&nbsp;2011&nbsp;</th></tr>";

// keeps getting the next row until there are no more to get

while($row = mysql_fetch_array( $result )) {

        // Print out the contents of each row into a table

        echo "<tr><td>&nbsp;"; 

        echo $row['KodMajikan'];

        echo "</td><td>&nbsp;"; 

        echo $row['NamaMajikan'];

        echo "</td><td align='center'>"; 

        echo $row['Bil2007'];

        echo "</td><td align='center'>"; 

        echo $row['Bil2008'];

        echo "</td><td align='center'>"; 

        echo $row['Bil2009'];

        echo "</td><td align='center'>"; 

        echo $row['Bil2010'];

        echo "</td><td align='center'>"; 

        echo $row['Bil2011'];

        echo "</td><td align='center'>"; 

        echo $row['Amt2007'];

        echo "</td><td align='center'>"; 

        echo $row['Amt2008'];

        echo "</td><td align='center'>"; 

        echo $row['Amt2009'];

        echo "</td><td align='center'>"; 

        echo $row['Amt2010'];

        echo "</td><td align='center'>"; 

        echo $row['Amt2011'];

        echo "</td><td align='center'>"; 

        echo $row['JumlahBesar'];

        echo "</td></tr>"; 

        

} 



echo "</table></center>";

?>