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)"
<Robert.Mcgraw@stripped>
To: <mysql@stripped>
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 <mysql-thread132697@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-jerry=metalcat.net@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
