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

Reply via email to