$con=mysql_connect(‘localhost‘,‘root‘,”); 
mysql_select_db(‘abc‘,$con); 
$sql = “select * from book”; 
$result = mysql_query($sql); 

//fetch_row只能用数组索引 $row[index]
while($row = mysql_fetch_row($result)) 
{ 
    echo $row[0]; //从0开始
} 
 
//fecth_assoc只能用数组的KEY $row[‘key‘]
while($row = mysql_fetch_assoc($result)) 
{ 
    echo $row[‘name‘]; 
} 

//fetch_array都可以用索引、KEY都可用（index,key）
while($row = mysql_fetch_array($result)) 
{ 
    echo $row[‘cid‘];
    echo $row[1]; 
} 

//fetch_object用对象方式调用数据 $row->id
while($row = mysql_fetch_object($result)) 
{ 
    echo $row->cid;
    echo $row->title; 
}