I tried to loop a associative array by using "for" statement, but it dosen't work, I don't know why.Please have a look at below. Many thanks!
<?php
$user="llama";
$pass="osti";
$db="funpic";
$link=mysql_connect("localhost",$user,$pass);
if(!link)
die("couldn't connect MYSQL");
mysql_select_db($db,$link)or die("couldn't open $db:".mysql_error());
$rows_per_page=30;
if(!isset($screen))
$screen=0;
$start=$screen*$rows_per_page; //setting the start point of each page
$sql="SELECT filename,name FROM PicInfo ";
$sql.="LIMIT $start,$rows_per_page";
$result=mysql_query($sql,$link);
$total_records=mysql_num_rows($result); //the number of the links
$pages=ceil($total_records/$rows_per_page); // number of pages
$arrayresult=mysql_fetch_array($result,MYSQL_ASSOC);
echo"<p><hr></p>\n";
//create a dynamic links
if($screen>0){
echo"<a href=\"$url\">Previous</a>\n";
}
for($x=0;$x<=10;$x++){
$var1=$arrayresult[$x]['filename'];
$var2=$arrayresult[$x]['name'];
print $var1;
print $var1;
}
if ($screen<$pages) {
$url="http://mili.phpwebhosting.com/~llama/FunPicSite/PicLink2.php?screen=" . ($screen + 1);
echo "<a href=\"$url\">Next</a>\n";
}
?>
