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
}