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? 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)? 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. 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
Archived
This topic is now archived and is closed to further replies.