<?
include("connect.php") ;
mysql_select_db($db) ;
$result = mysql_query("select name and province from member ") or die ("Can not to result") ;
$name = mysql_fetch_array($result) ;
echo"$name";
?>
<?
include("connect.php") ;
mysql_select_db($db) ;
$result = mysql_query("select name and province from member ") or die ("Can not to result") ;
$rowmax=mysql_num_rows($result);
$name = mysql_fetch_array($result) ;
$i=1;
while($i<=$rowmax)
{
echo $name['name']."-->".$name['province']."<br />";
$i++;
}
mysql_free_result($result);
?>
// ----------------------------------------------------------------------------------
<?
include("connect.php") ;
mysql_select_db($db) ;
$result = mysql_query("select name and province from member ") or die ("Can not to result") ;
while($row= mysql_fetch_array($result))
{
echo $row[0]."-->".$row[1]."<br />";
}
mysql_free_result($result);
?>