tbl_reports and tbl_personnel
tbl_reports has these fields:
rep_id, person1, person2, person3, person 4
tbl_personnel has these fields:
per_id, fname, lname, mname
What is the way to get each report back once, and have the fname, mname, and lname fields available to print to the screen in PHP for each person1, person2, person3, person4 (which contain per_id)?
TIA
- Charles
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
