I am a beginner and need some quick help. Will pay if necessary.
Help #1: I need to copy records from table checklistform to table checklist_history.. The min number records per prod_id will be 12
//Step 1 - copy all existing records Checklistfrom where prop_id is the one being made vacant and insert into Checklist_history.
$mysql1 = "INSERT INTO Checklist_history SELECT * FROM Checklistform WHERE prop_id='$prop_id'";
//Step 2 - delete records from Checklistform where prod_id is being made vacant.
$mysql2 = "Delete from Checklistform where prop_id='$prop_id'"; mysql_query($sql);
Help #2: Put a variable in confirm text.
form action="owner_changeto_vacantproperty.php?prop_id=" method="post" enctype="multipart/form-data" name="vacant" id="vacant" onSubmit="return confirm_deactivate()">
var yes=confirm('Are you sure you wish to deactivate this property! (would like to show the $prop_id');
return true ;
return false ;