$date =$_POST['date'];
$job_name =$_POST['job_name'];
$teamname =$_POST['teamname'];
$e_notes =$_POST['e_notes'];
if($teamname="Gary & Marty")
{
mysql_query("UPDATE electrical SET garyandmarty='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="Rod & Ben")
{
mysql_query("UPDATE electrical SET rodandben='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="Brian & Keith")
{
mysql_query("UPDATE electrical SET brianandkeith='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="Jeff & Aaron")
{
mysql_query("UPDATE electrical SET jeffandaaron='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="Bob & Scott")
{
mysql_query("UPDATE electrical SET bobandscott='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="Kelvyn & Jeremy")
{
mysql_query("UPDATE electrical SET kelvynandjeremy='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="John & Kyle")
{
mysql_query("UPDATE electrical SET johnandkyle='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="Scott & Mike")
{
mysql_query("UPDATE electrical SET scottandmike='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="Matt & Brandon")
{
mysql_query("UPDATE electrical SET mattandbrandon='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="BLOCK")
{
mysql_query("UPDATE electrical SET block='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="Pending1")
{
mysql_query("UPDATE electrical SET pending1='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="Pending2")
{
mysql_query("UPDATE electrical SET pending2='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="RFQ1")
{
mysql_query("UPDATE electrical SET rfq1='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
if($teamname="RFQ2")
{
mysql_query("UPDATE electrical SET rfq2='$job_name',e_notes='$e_notes' WHERE date='$date'");
}
echo "You have <font color='#990000'><strong>successfully</strong></font> add a job to electrical division<br>";
echo "To add another job to electrical division click <a href='addelectrical.php'>here</a><br>";
echo "To return to home page click <a href='home.php'>here</a><br>";
[Ovu poruku je menjao Nemanja Avramović dana 20.02.2007. u 22:10 GMT+1]