Php easy paging

Php simple paging & lt ;! DOCTYPEhtmlPUBLIC-W3CDTDXHTML1.0TransitionalENwww.w3.orgTRxhtml1DTDxhtml1-transitional.dtd & gt; & lt; htmlxmlnswww. w3.org5oxhtm php simple paging

Untitled Document

$ Conn = mysql_connect ("localhost", "root", "123 ");
Mysql_select_db ("qq", $ conn );
Mysql_query ("set names utf8 ");
$ Length = 5;
$ Pagenum = isset ($ _ GET ['Page'])? $ _ GET ['Page']: 1;
$ Totsql = "select count (*) from q1 ";
$ Totarr = mysql_fetch_row (mysql_query ($ totsql ));
$ Pagetot = ceil ($ totarr [0]/$ length );
If ($ pagenum >=$ pagetot ){
$ Pagenum = $ pagetot;
}
$ Offset = ($ pagenum-1) * $ length;
$ SQL = "select * from q1 order by id limit {$ offset}, {$ length }";
$ Ret = mysql_query ($ SQL );
Echo"

";
Echo"







";While ($ row = mysql_fetch_assoc ($ ret )){Echo" ";Echo" ";Echo" ";Echo" ";Echo" ";}Echo"

{$ Row ['id']}	{$ Row ['name']}	{$ Row ['pass']}

";
$ Prevpage = $ pagenum-1;
$ Nextpage = $ pagenum + 1;
Echo "up | down ";
Echo" ";
Mysql_close ($ conn );

?>