I have created a form which puts the data in to MySql database. I have 3 fields that are not filled out in the initial form. These 3 fields are going to be for my admins to enter the results. I will have a compeletly seperate form for the admins to enter thier data. The 3 fields they will have to fill out is datecomp_field, findings_field and penalty_field. Now how do I create it so they can select the record they want to added the the data of these fields into? For example, lets say I have 10 records in my database already. They are complete with number 7. How do I added the 3 above fields just for record number 7?
Here is the php code I am using to enter the data in my initial form.
<?
$conection=mysql_connect("", "", "");
mysql_select_db("FASCAR", $conection);
mysql_select_db("FASCAR");
mysql_query("insert into committee1(date_field, division_field, submittedby_field, submittedbyid_field, submittedon_field, submittedonid_field, carnumber_field, racenumber_field, track_field, lap_field, yellowflag_field, incident_field, comments_field, replayname_field) VALUES ('$date', '$division', '$submittedby', '$submittedbyid', '$submittedon', '$submittedonid', '$carnumber', '$racenumber', '$track', '$lap', '$yellowflag', '$incident', '$comments', '$replayname')");
?>
I am new to this so any help is appreciated.