I'd create a table with id, username, ,badgenumber, url.
then have i.e. 1, Jerry, 007, /dir/images/jerry.jpg 2, Bob, 008, /dir/images/bob.jpg or something like that. The scripting to get that out and generate the html would be very easy. There are a few examples here that would cover what you want : http://www.devshed.com/Server_Side/PHP Jerry ----- Original Message ----- From: "McGraw, Robert--G3(Contractor-ANTEON Corp)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 3:24 PM 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