[Resolved] PHP5 and MS SQL 7.0 and IIS 5.0

[tenchi96]

I'm having problems here is my code
<?
$s = @mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");

$d1 = @mssql_select_db($myDB1, $s)
or die("Couldn't open database $myDB1");

$result = mssql_query('SELECT Username FROM TECH');
$numRows = mssql_num_rows($result);

echo "<h1>".$numRows ." Row" .($numRows == 1 ? " " : "s") . " Returned </h1>";

while($row = mssql_fetch_array($result))
{
echo "<li>".$row."</li>";
}

?>

When i run my code all that is displayed on the is

18 Rows Returned
Array
Array
Array
Array
Array
Array
Array
Array
Array
Array
Array
Array
Array
Array
Array
Array
Array
Array

Please Help Me.

[liquorvicar]

$row = mssql_fetch_array($result)

returns an array hence when you echo($row) it prints Array. if you want to print the username try

echo($row['Username']);

[tenchi96]

Thanks it worked

[liquorvicar]

ok, can you mark the thread RESOLVED then...