If I use this code I get nothing: [code] <html> <head> <title>Wines</title> </head> <body><pre> <?php // (1) Open the database connection and select the // winestore $connection = mssql_connect('localhost', 'usr', 'pass'); mssql_select_db("mydb", $connection); // (2) Run the query on the winestore through the // connection $result = mssql_query("select * from table1", $connection); // (3) While there are still rows in the result set while ($row = mssql_fetch_row($result)) { // (4) Print out each attribute in the row for ($i=0; $i<mssql_num_fields($result); $i++) echo $row[$i] . " "; // Print a carriage return to neaten the output echo "\n"; } // (5) Close the database connection mssql_close($connection); ?> </pre> </body> </html> [/code] but if I select a particular column then it works [code] <html> <head> <title>Wines</title> </head> <body><pre> <?php // (1) Open the database connection and select the // winestore $connection = mssql_connect('localhost', 'usr', 'pass'); mssql_select_db("mydb", $connection); // (2) Run the query on the winestore through the // connection $result = mssql_query("select id from table1", $connection); // (3) While there are still rows in the result set while ($row = mssql_fetch_row($result)) { // (4) Print out each attribute in the row for ($i=0; $i<mssql_num_fields($result); $i++) echo $row[$i] . " "; // Print a carriage return to neaten the output echo "\n"; } // (5) Close the database connection mssql_close($connection); ?> </pre> </body> </html> [/code] Am I not able to use SELECT * in MSSQL? it works fine in query analyzer. Am I missing something?