Example of php while loop recording the number of loops

//Record the number of while loops
//by bbs.it-home.org
 $link = mysql_connect('localhost','root','pwd');
 mysql_select_db( 'db');
 $sql = "select region_id,local_name from regions where region_grade=1";
 $result = mysql_query($sql);
 $i =0;
 while ($row= mysql_fetch_assoc($result)) {
 $list[$i]['text']=$row['local_name'];
 $list[$i]['value']=$row['region_id'];
 $i++;
 }
 $list = json_encode($list);
 echo $list;
?>

and record it, I might use it one day.