復制代碼 代碼如下:

require 'dbconn.php';
$sql = 'select * from _Test';
$query = mssql_query($sql);
while($row=mssql_fetch_row($query))
{
echo $row['UserId'].'::'.$row[1].'<br>';
}

復制代碼 代碼如下:

$query = mssql_query($sql);
while($row=mssql_fetch_assoc($query))
{
echo $row['UserId'].'::'.$row[1].'<br>';
}

復制代碼 代碼如下:

<?php
$query = mssql_query($sql);
while($row=mssql_fetch_array($query))
{
echo $row['UserId'].'::'.$row[1].'<br>';
}
?>

復制代碼 代碼如下:

$query=mssql_query($sql);
while($row=mssql_fetch_object($query))
{
echo $row->UserId.'::'.$row->CreateTime."<br>";
}