分页问题?急!!!
请大家帮忙看一下,下面的这段代码为什么不能实现分页效果,每次总是显示前两条信息,点击下一页或上一液,显示的还是登陆界面时的两条信息,不能实现分页,请大家指点!!
<?php
include("connect.php");
$db="sw";
$table="ssww";
$result1 = @mysql_select_db($db);
$str_sql = "select * from $table";
$str=mysql_db_query($db,$str_sql);
$num_records=@mysql_num_rows($str);
$num_to_show=2;
$str_sql="select * from $table order by id desc";
if(!$init_record)$init_record=0;
$str_sql.="limit $init_record,$num_to_show";
$fields=@mysql_list_fields($db,$table);
$num_fields=@mysql_num_fields($fields);
$result=@mysql_query($db,$str_sql);
$records=@mysql_num_rows($result);
echo "$table"."中现有"."$num_records"."条记录";
echo "<table border=1><tr>";
for($j;$j<$num_fields;$j++)
{
$field=@mysql_field_name($fields,$j);
echo '<th>$field</th>';
}
echo '</tr>';
for($i=0;$i<$records;$i++)
{
echo '<tr>';
$record = @mysql_fetch_object($result);
for ($j=0; $j<$num_fields; $j++)
{
$field = @mysql_field_name($fields, $j);
echo '<td>'.$record ->$field.'</td>';
}
echo '</tr>';
}
echo '</table>';
$next_record=$init_record+$num_to_show;
if($next_record>$num_records)$next_record=$num_records;
$prev_record=$init_record-$num_to_show;
if($prev_record<0)$prev_record=0;
echo '<br>';
$link_order1="init_record=$next_record";
echo "<a href=\"fenye.php?init_record=$link_order1\">下一页</a>";
$link_order2="init_record=$prev_record";
echo "<a href=\"fenye.php?init_record=$link_order2\">上一页</a>";
?>