Hi all,
I'm quite a newbie, but I'm learning, smile!
I have built a report for a local fire department, where they can enter the details of each incident they attend. On this form is a section wherer they can list the firefighters attending an incident.
I had it so that they could put in the name and their ID, so that both would appear on the report, but they have asked me to work it out so that they can just put in the ID number, and the report would pull the rest of the information through from the relevant database table. I have the separate database table, but I have no clue how to get the php page to pull it through.
Here is what I have now, any thoughts or even pointing me to a tutorial that covers this would be appreciated.
<?php echo $row_PERSONNEL['2_PERSONNEL_ID']; ?> <?php echo $row_PERSONNEL['2_PERSONNEL_RANK']; ?> <?php echo $row_PERSONNEL['2_PERSONNEL_NAME']; ?><br />
<?php echo $row_PERSONNEL['2_PERSONNEL_ACTIONS_TAKEN_1']; ?><br />
<?php echo $row_PERSONNEL['2_PERSONNEL_ACTIONS_TAKEN_2']; ?><br />
<?php echo $row_PERSONNEL['2_PERSONNEL_ACTIONS_TAKEN_3']; ?><br />
<?php echo $row_PERSONNEL['2_PERSONNEL_ACTIONS_TAKEN_4']; ?><br />
The code above simply lists what they have entered. '2_PERSONNEL_ID' has the same details as a field in another table called "Members", which contains the other information listed here. How can I pull it across if they only fill in the '2_PERSONNEL_ID' on the form.
Many thanks!
