title: print a value from a select statement in PHP
body: <p>All I am trying to do is display the price of an item from an mysql database in an <code>&lt;h1&gt;</code> tag.  Nothing fancy or difficult.  I have a page that has 60 item on it, and I need to update prices on our database 2 to 3 times a year.  This would keep this page consistent with the database.</p>
  
  <p>I have establish a standard mysql connect. I have defined a variable from a select statement.  Now I just need to know how to display the info. when I run this php, I get an error "Notice: Undefined variable: products in /Applications/MAMP/htdocs/staging/dynamic_mixers.php on line 123"</p>
  
  <p>Below is my code. </p>
  
  <pre><code>$products = "SELECT Base_Price FROM products Where record_number=1072;
  echo "&lt;h1&gt;'.$products['Base_Price'].&lt;/h1&gt;
  </code></pre>