6 messages in com.mysql.lists.win32RE: How to handle Images from DB dyna...
FromSent OnAttachments
Subbakrishna15 Sep 1999 00:19 
Dennis Thrysøe15 Sep 1999 00:29 
Fredrik Davidsson15 Sep 1999 00:34 
Bob Kline15 Sep 1999 04:44 
Mike Canonigo15 Sep 1999 07:49 
Mike Canonigo15 Sep 1999 07:50 
Subject:RE: How to handle Images from DB dynamically
From:Mike Canonigo (MCan@parksite.com)
Date:09/15/1999 07:50:54 AM
List:com.mysql.lists.win32

BY MISTAKE, ON THE #2, THERE IS NO PERIOD "." AFTER PIC IN THE DATABASE

-----Original Message----- From: Mike Canonigo [SMTP:MCan@parksite.com] Sent: Wednesday, September 15, 1999 9:50 AM To: win@lists.mysql.com Subject: RE: How to handle Images from DB dynamically

not2 ways I've been able to do this

1. I've stored the file name with the .jpg ( or watever ) extension

+---------------+ | PicName | +---------------+ | pic.jpg | +---------------+

then when I call it,

echo "<img src=\"location_of_file/$mysql_row->PicName\">";

obviously, you would have to create a query and do a mysql_fetch_object

2. just about the same, the only difference is not putting on the picture extension

+---------------+ | PicName | +---------------+ | pic. | +---------------+

then when you call it

echo "<img src=\"location_of_file/$mysql_row->PicName.jpg\">";

again, a query and mysql_fetch_object are assumed to be done here

-----Original Message----- From: Subbakrishna [SMTP:sub@excelindia.com] Sent: Wednesday, September 15, 1999 2:20 AM To: win@lists.mysql.com Subject: How to handle Images from DB dynamically

Hi !

How to display images stored in a database onto a HTML Page.

Bye

Subbakrishna M.V.

---------------------------------------------------------------------

Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3@lists.mysql.com instead.

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3@lists.mysql.com instead.