mysql_fetch_array()与mysql_fetch_assoc()、mysql_fetch_row()

mysql_fetch_array()

从结果集中取得一行作为关联数组或者索引数组

array (size=2)
  0 => 
    array (size=10)
      0 =>  "7" (length=1)
      "id" =>  "7" (length=1)
      1 =>  "2" (length=1)
      "pid" =>  "2" (length=1)
      2 =>  "????" (length=4)
      "catename" =>  "????" (length=4)
      3 =>  "0" (length=1)
      "cateorder" =>  "0" (length=1)
      4 =>  "0" (length=1)
      "createtime" =>  "0" (length=1)
  1 => 
    array (size=10)
      0 =>  "8" (length=1)
      "id" =>  "8" (length=1)
      1 =>  "2" (length=1)
      "pid" =>  "2" (length=1)
      2 =>  "????" (length=4)
      "catename" =>  "????" (length=4)
      3 =>  "0" (length=1)
      "cateorder" =>  "0" (length=1)
      4 =>  "0" (length=1)
      "createtime" =>  "0" (length=1)

mysql_fetch_assoc()

从结果集中取得一行作为关联数组

array (size=2)
  0 => 
    array (size=5)
      "id" =>  "7" (length=1)
      "pid" =>  "2" (length=1)
      "catename" =>  "????" (length=4)
      "cateorder" =>  "0" (length=1)
      "createtime" =>  "0" (length=1)
  1 => 
    array (size=5)
      "id" =>  "8" (length=1)
      "pid" =>  "2" (length=1)
      "catename" =>  "????" (length=4)
      "cateorder" =>  "0" (length=1)
      "createtime" =>  "0" (length=1)

mysql_fetch_row()

从结果集中取得一行作为索引数组

array (size=2)
  0 => 
    array (size=5)
      0 =>  "7" (length=1)
      1 =>  "2" (length=1)
      2 =>  "????" (length=4)
      3 =>  "0" (length=1)
      4 =>  "0" (length=1)
  1 => 
    array (size=5)
      0 =>  "8" (length=1)
      1 =>  "2" (length=1)
      2 =>  "????" (length=4)
      3 =>  "0" (length=1)
      4 =>  "0" (length=1)

另外注意，这几个函数都只是从结果集中仅仅取得一条记录，因此我们还需要遍历结果集才能获取所有数据，例如

$results = array();
while($result1 = mysql_fetch_row($result)){
	$results[] = $result1;
}