title: MySQL Select* returns everything but the id column
body: <p>I have a database with 2 tables I wish to pull data from both and display it in an html table. When I execute the below select statement I seem to get everything but the auto_increment column "id"</p>
  
  <pre><code>&gt;mysql connection strings here.
  
  $query = "SELECT Hotels.*,surfcup_Rates.*
            FROM Hotels 
                 LEFT JOIN surfcup_Rates
                 ON Hotels.id=surfcup_Rates.hotelID";
  </code></pre>
  
  <p>Then I use load the query into $result.
  Later I load it into mysql_fetch_array and loop it into an html table.</p>
  
  <pre><code>while ($row = mysql_fetch_array($result)) {
      echo "&lt;/td&gt;&lt;td&gt;";
      echo '&lt;a href="DeleteHotelRecord.php?id="['.$row['id'].']"&gt;Delete&lt;/a&gt;';
      echo "&lt;/td&gt;&lt;td&gt;";
      echo $row['id'];
      echo "&lt;/td&gt;&lt;td&gt;";
      echo $row['preferred'];
  &gt;and so on...........
  </code></pre>
  
  <p>Everything works: the join, the select statement and data loads into the table
  perfectly. All except the <code>id</code> column from the first table. I wish to use the <code>id</code> to allow the user to delete a record. The user will be adding data to the tables from a password protected "back-end" for data entry. </p>
  
  <p>Is there something wrong with my select statement? Or am I missing something. Any help will be greatly appreciated.
  Thank You, 
  Dave.</p>