List:General Discussion« Previous MessageNext Message »
From:Jerry Date:February 18 2003 4:18pm
Subject:Re: Question
View as plain text  
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
>

Thread
QuestionRobert--G3(Contractor-ANTEON Corp) McGraw18 Feb
  • RE: QuestionRob18 Feb
  • RE: QuestionMadscientist18 Feb
  • Re: QuestionRoger Baklund18 Feb
  • Re: QuestionJerry18 Feb