Problem sa insert-om

[ djovan01 @ 20.02.2007. 18:53 ] @

If recenice mi ne funkcionisu kako treba i nemam pojma sta je u pitanju. Kada izaberem opciju sa liste formulara insert je izvrsen u svako polje u bazi. Zasto? kad sam postavila if recenice koje ce proveriti sta je u sacuvano u $teamname variabli i na osnovu toga izvrsiti insert. U cemu je greska?

Code:
$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 successfully add a job to electrical division ";
echo "To add another job to electrical division click <a href='addelectrical.php'>here</a> ";
echo "To return to home page click <a href='home.php'>here</a> ";

_{[Ovu poruku je menjao Nemanja Avramović dana 20.02.2007. u 22:10 GMT+1]}