title: Displaying BLOB files in PHP script
body: <p>This is my PHP script which displays a radio station's schedule:</p>
  
  <pre><code>    &lt;div class="divider"&gt;&lt;/div&gt;
      &lt;div class="main" style="width:552px;"&gt;
          &lt;img src="$image" width=115 height=60&gt;
          &lt;div class="time"&gt;$airtime&lt;/div&gt;
          &lt;div class="show"&gt;&lt;h3&gt;&lt;a href="$link&gt;&lt;b&gt;$presenter&lt;/b&gt;&lt;/a&gt;&lt;/h3&gt;
              &lt;p&gt;$showdesc&lt;/p&gt;&lt;/div&gt;
          &lt;div class="footer"&gt;&lt;/div&gt;
      &lt;/div&gt;
      &lt;/div&gt;
                  &lt;div class="footer"&gt;&lt;/div&gt;
                  &lt;div class="bottom"&gt;&lt;/div&gt;
              &lt;/div&gt;
  </code></pre>
  
  <p>The values with the dollar sign represent the field names in my database, which is radiopresenters.</p>
  
  <p>How would I get this to work as a PHP script, and display the values from the database?
  All values in the fields are stored in TEXT format, apart from the <strong>image</strong> field which is stored in BLOB format.</p>
  
  <p>Airtime is stored in a separate database entitled as <strong>radioschedule</strong> which has all 4 fields ib, and I intend to link these together via some relational means.</p>
  
  <p>What's the best way to get it to display as the above, especially the BLOB part?</p>