Jump to content

Archived

This topic is now archived and is closed to further replies.

nitrox007

problem using "SELECT *" with mssql DB

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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)?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.