PHP and mssql problem (only print one record)

When I use the code below:

$result=mssql_query("select * from table");
$rows=mssql_fetch_row($result);
print_r($rows);

The print is only one record of the table "table".
like this:
Array
(
[0] => 1
[1] => 2
[2] => 3
)

But,actually,there are more than one record in this table.
And also it is no problem in the connection of the database.

What's possible reasons are there?

 

you need a loop

$result=mssql_query("select * from table");
while ($rows=mssql_fetch_row($result)){
print_r($rows);
}

Code (markup):

 

oh,thanks.