title: Mysql select and display two column
body: <p>I want to extract two types of data which is store in the same column of my table and display it in two column. I have do many search and do many test but nothing works. 
  It could be easy to do...</p>
  
  <p>This is my table:</p>
  
  <pre><code>| id  | field_id | user_id | value            | 
  | 175 |       65 |       3 | 48.8984188201264 | 
  | 173 |       65 |       2 | 37.9841493       | 
  | 177 |       65 |       4 | 48.8440603       | 
  | 179 |       65 |       5 | 48.8407529       | 
  | 174 |       66 |       2 | 23.7279843       | 
  | 176 |       66 |       3 | 2.25568230749569 | 
  | 178 |       66 |       4 | 2.3730525        | 
  | 180 |       66 |       5 | 2.3213214        | 
  </code></pre>
  
  <p>I want to display latitude (Field_id=65) in one field and longitude (field_id= 66) in another one by joining on the user_id.</p>
  
  <p>Two select:</p>
  
  <pre><code>select value as longitude 
  from wp_bp_xprofile_data 
  where field_id=66; 
  
  select value as latitude 
  from wp_bp_xprofile_data 
  where field_id=65;
  
  | longitude        |
  | 23.7279843       |
  | 2.25568230749569 |
  | 2.3730525        |
  | 2.3213214        |
  
  | latitude         |
  | 48.8984188201264 |
  | 37.9841493       |
  | 48.8440603       |
  | 48.8407529       |
  </code></pre>
  
  <p>How I can display this data in one table with two column?</p>
  
  <p>Thanks</p>