mysql_fetch_array 与 mysql_fetch_row的区别

mysql_fetch_array()既可以数字索引，也可字段索引，而mysql_fetch_row()只能进行数字索引 ，mysql_fetch_assoc只能进行字段索引，mysql_fectch_object()生成的是对象。上例：

create database `test` charset utf8;
use `test`;
create table `test` (
        id tinyint not null primary key auto_increment,
name varchar(25)
) charset utf8;

insert into `test` values(null, 'zhangsan'),
(null, 'lishi'),(null, wangwu);
$sql = "select * from `test`";
$query = mysql_query($sql);
while($result = mysql_fectch_array($query)) {
echo $result[0]; //right
echo $result['name']; //right
}
while($result = mysql_fetch_row($query)) {
echo $result[0]; //right
        echo $result['name']; //wrong
}
while($result = mysql_fetch_assoc) {
echo $result[0]; //wrong;
echo $result['name']; //right
}
while($result = mysql_fetch_object) {
  echo $result[0]; //wrong;
echo $result['name']; //wrong
echo $result->name; //right
}