php mysql 只获取到第一条数据,php – mysql_fetch_assoc只获取一条记录

我有一个包含查询结果的数组：

.....some code.....

$result = mysql_query("SELECT * FROM vttest");

$row = mysql_fetch_assoc($result);

print_r($row);

但它只打印一条记录,我不能把$row放在一个循环中,因为我将在稍后对该变量进行排序.

Array

(

[id] => 3

[rep] => Mike

[name] => Joe

[department] => Business

[location] => Room 1

[email] => xxxx@hotmail.com

[phone] => 519-123-4567

[type] => Visit

[drink] => Coffee

[notes] => Some notes

[lastVisited] => 2010-08-27

[nextVisit] => 2010-08-27

)

我知道有更多的记录,我怎么能打印所有它仍然能够使用$row变量？