Displaying BLOB files in PHP script

nelliesienna

New Member
This is my PHP script which displays a radio station's schedule:\[code\] <div class="divider"></div> <div class="main" style="width:552px;"> <img src="http://stackoverflow.com/questions/3713253/$image" width=115 height=60> <div class="time">$airtime</div> <div class="show"><h3><a href="http://stackoverflow.com/questions/3713253/$link><b>$presenter</b></a></h3> <p>$showdesc</p></div> <div class="footer"></div> </div> </div> <div class="footer"></div> <div class="bottom"></div> </div>\[/code\]The values with the dollar sign represent the field names in my database, which is radiopresenters.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 image field which is stored in BLOB format.Airtime is stored in a separate database entitled as radioschedule which has all 4 fields ib, and I intend to link these together via some relational means.What's the best way to get it to display as the above, especially the BLOB part?
 
Back
Top