nitrox007
-
Posts
2 -
Joined
-
Last visited
Never
nitrox007's Achievements
Newbie (1/5)
0
Reputation
-
problem using "SELECT *" with mssql DB
nitrox007 replied to nitrox007's topic in Microsoft SQL - MSSQL
I figured out what the problem was. I had some 'ntext' fields that weren't coming through. I changed these to varchar and problem solved. the data contained in this field is just text to it worked fine. -
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?