Usually the best way to do this is to store the images in an accessible directory and then store the URL for the image in the database. It's a fairly simple exercise also to create an upload function that will associate the two for you automatically.
Hope this helps, _M ]-----Original Message----- ]From: McGraw, Robert--G3(Contractor-ANTEON Corp) ][mailto:[EMAIL PROTECTED]] ]Sent: Tuesday, February 18, 2003 10:24 AM ]To: '[EMAIL PROTECTED]' ]Subject: Question ] ] ]Sir/Ma'am, ] ]I am building a database (using MySQL) consisting of a list of ]emplyees with ]specific and unique information for each. I want to link an ]employees badge ]number with their photo. I have photos for all employees in JPG format. ]How can I link the badge number to a photo? Ideally, I would like to click ]on the badge number and the photo would come up. Any help is greatly ]appreciated. ] ]Thanks much. ] ] ]Robert D. McGraw ]Anteon Corporation ]Database Administrator ]Battle Simulation Center ]Ft. Hood, TX ]DSN 738 3061 Comm. (254) 288 3061 ] ] ] ]--------------------------------------------------------------------- ]Before posting, please check: ] http://www.mysql.com/manual.php (the manual) ] http://lists.mysql.com/ (the list archive) ] ]To request this thread, e-mail <[EMAIL PROTECTED]> ]To unsubscribe, e-mail ]<[EMAIL PROTECTED]> ]Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ] ] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php