[es] - Problem sa insert-om

djovan01

Član broj: 75700
Poruke: 196
208.65.70.*

Profil

^{20.02.2007. u 18:53 - pre 209 meseci}

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]}

Nemanja Avramović
Engineering Manager
MENU Technologies
Beograd, Srbija

Moderator
Član broj: 32202
Poruke: 4391
212.200.145.*

Sajt: https://avramovic.info

+46 Profil

Re: Problem sa insert-om

^{20.02.2007. u 21:12 - pre 209 meseci}

U uslov treba da dva znaka jednakosti. Probaj sa:

Code:
if ($teamname == "Gary & Marty) {
mysql_query('blabla');
}

Mislim da je to u pitanju. On ovako dodeli vrednost promenljivoj $teamname i to vraća true jer je uspeo da dodeli vrednost toj promenljivoj, i onda radi mysql_query.

Laravel Srbija.

_{[NE PRUŽAM PODRŠKU ZA PHP PREKO PRIVATNIH PORUKA!]}