Why don't you link the badge number to the url of the photo? e.g.
BadgeNumber PhotoURL 1 c:\MyPhoto\1.jpg 2 c:\MyPhoto\1.jpg etc ... Then you can get the URL and simply load the photo --- Rob ************************** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ************************** -----Original Message----- From: McGraw, Robert--G3(Contractor-ANTEON Corp) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 5:24 PM 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