title: mssql_fetch_array only displays one row if columns are put into variables
body: <p>I'm still a PHP noob, so I apologize if this is something simple. </p>
  
  <p>I am creating a fairly basic search facility for a website using PHP and mySQL. I have connected to the database, selected the database, queried the table and have fetched the table columns; </p>
  
  <pre><code>$k = htmlspecialchars($_GET['k']); // Get search query
  
  $select = mssql_query("SELECT * FROM search WHERE Title Like '%" . $k . "%'");
  
  if( mssql_num_rows($select) &lt; 1) {
  
  $noResults = 'No results found for &lt;b&gt;' . $k . '&lt;/b&gt;, &lt;label for="k"&gt;Please try again.&lt;/label&gt;';
  
  } else {
  
  while ($results = mssql_fetch_array($select)) {
  
      $title = $results['Title'];
      $link = $results['Link'];
      $description = $results['Description'];
  
  }
  
  }
  </code></pre>
  
  <p>When I put the $results[''] columns into variables and then try to echo out each variable like so;</p>
  
  <pre><code>             if( isset($noResults)) {
  
                  echo $noResults;
  
              } else { 
  
                  echo '&lt;li&gt;' . '&lt;h2&gt;' . '&lt;a href="' . $link . '" title="' . $title . '"&gt;' . $title . '&lt;/a&gt;' . '&lt;/h2&gt;' . '&lt;p&gt;' . $link . '&lt;/p&gt;' . '&lt;p&gt;' . $description . '&lt;/p&gt;' . '&lt;/li&gt;'; 
  
               }
  </code></pre>
  
  <p>it only echo's out one row matching that query however, If I was to just simple echo out the columns like so;</p>
  
  <pre><code>    echo $results['Title'];
      echo $results['Link'];
      echo $results['Description'];
  </code></pre>
  
  <p>all rows matching the query will be displayed..</p>
  
  <p>I'm not sure why this is happening. If someone could help me out that would be great!</p>