nitrox007 Posted October 30, 2006 Share Posted October 30, 2006 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? Quote Link to comment https://forums.phpfreaks.com/topic/25621-problem-using-select-with-mssql-db/ Share on other sites More sharing options...
MCP Posted October 31, 2006 Share Posted October 31, 2006 It definitely should..what do you get when you put a var_dump($row); or print_r($row); in the while loop? what's the value of mssql_num_fields($result)? Quote Link to comment https://forums.phpfreaks.com/topic/25621-problem-using-select-with-mssql-db/#findComment-117100 Share on other sites More sharing options...
nitrox007 Posted October 31, 2006 Author Share Posted October 31, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/25621-problem-using-select-with-mssql-db/#findComment-117315 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.