Robcole

         mysql_query( "INSERT INTO jobs VALUES (NULL,'$jobtitle', '$industry', '$mineducation', '$workstatus', '$jobdescription', '$jobrequirements', '$jobbenefits', '$posteddate', '$employerid')" ) or die( mysql_error( ));

$query="DELETE tempjobs FROM tempjobs WHERE tempjobs.employer_id = employer.employer_id AND tempjobs.id ='$iid'";
mysql_query($query);