RE: [PHP] RE: Display picture from MySQL

Here is my situation I have 3 record data as (lotID is char and Picture is longblob type) LotId |Picture --------------- 123 |Picture1 124 |Picture2 125 |Picture3 then I would like to display like this >>>>>>>>>>> Lot ID : 123 Picture: Picture1 Lot ID : 124 Picture: Picture2 Lot ID : 125 Picture: Picture3 >>>>>>>>>>> Or maybe thumbnail view. How I can do this? Thanks -----Original Message----- From: Richard Lynch [mailto:ceo@l-i-e.com] Sent: Friday, July 08, 2005 3:58 AM To: Bagus Nugroho Cc: replies-lists-php@listmail.innovate.net; php-general@lists.php.net Subject: RE: [PHP] RE: Display picture from MySQL On Thu, July 7, 2005 12:32 pm, Bagus Nugroho said: > How about, if we need several pictures from several record? You can create a page of HTML that has IMG tags, and each IMG tag can call ANOTHER php script that sends out one, and only one, image. You'll never ever get two images crammed into a single HTTP request/response. You also cannot smush the HTML and the IMG itself all into one file/script. HTML with IMG tag is one script. Actual image output (JPEG, GIF, etc) is another. * Actually, they can be the same "script" if enough code is shared, but it's got to have an "if" in there and only output the HTML for the .htm request, and only output the JPEG for the .jpg request, but that's for another day, after you get it working in separate scripts. -- Like Music? http://l-i-e.com/artists.htm