page1
page2
$conn = mysql_connect("localhost", "mtchang", "qw") or die("Could not connect");
mysql_query("SET NAMES 'utf8'");
mysql_select_db("mtchang", $conn);
$page_max=10;
$page_start=$page_max*$_GET['page'];
$sql = "select * from students limit $page_start,$page_max";
$result = mysql_query($sql);
$nbfields = mysql_num_fields($result);
echo "\n";
echo "\n" ;
while ($field = mysql_fetch_field($result))
{
echo "" . $field->name . " | ";
}
echo "
\n";
while ($row = mysql_fetch_row($result))
{
echo "\n";
for($i = 0 ; $i < $nbfields ; $i++)
{
echo "" . $row[$i] . " | ";
}
echo "
\n";
}
echo "
";
?>