| Benutzer
Registriert seit: 28.12.2008
Beiträge: 92
|  [Erledigt] Variable wird nicht übernommen
Hallo Leute hab ein kleines Problem mit einer Variable weiß nicht wieso diese nicht übernommen wird.
Es wird die Variable Objekt nicht richtig übernommen wenn die Variable Abocode ändere. PHP-Code:
if (!empty($_POST["bearbeiten"]) and $_POST["bearbeiten"]=="bearbeiten")
{
$aVKZ = $_POST['VKZ'];
$VKZ = $_POST['aaVKZ'];
$aabocode = $_POST['Abocode'];
$Abocode = $_POST['aaabocode'];
$aagent = $_SESSION['user_vpnummer'];
$Orga_Nummer = "8740";
$sqla = "SELECT
prov02, prov03, prov04, prov05, prov06, prov07, prov08, prov09, prov10, prov11, prov12, prov13, prov14, prov15, prov16, prov17, prov18, prov19, prov20, prov21, prov22, prov23, prov24, prov25, prov26, prov27, prov28, prov29, prov30, prov31, prov32, prov33, prov34, prov35, prov36, prov37, prov38, prov39, prov40, prov41, prov42, prov43, prov44, prov45, prov46, prov47, prov48, prov49, prov50, prov51, prov52, prov53, prov54, prov55, prov56, prov57, prov58, prov59, prov60, prov61, prov62, prov63, prov64, prov65, prov66, prov67, prov68, prov69, prov70, prov71, prov72, prov73, prov74, prov75, prov76, prov77, prov78, prov79, prov80, prov81, prov82, prov83, prov84, prov85, prov86, prov87, prov88, prov89, prov90, prov91, prov92, prov93, prov94, prov95, prov96, prov97, prov98, prov99, prov100, prov101, prov102, prov103, prov104, prov105, prov106, prov107, prov108, prov109, prov110, prov111, prov112, prov113, prov114, prov115, prov116, prov117, prov118, prov119, prov120, prov121, prov122, prov123, prov124, prov125, prov126, prov127, prov128, prov129, prov130, prov131, prov132, prov133, prov134, prov135, prov136, prov137, prov138, prov139, prov140, prov141, prov142, prov143, prov144, prov145, prov146, prov147 prov148, prov149, prov150, prov151, prov152, prov153, prov154, prov155, prov156, prov157, prov158, prov159, prov160, prov161, prov162, prov163, prov164, prov165, prov166, prov167, prov168, prov169, prov170, prov171, prov172, prov173, prov174, prov175, prov176, prov177, prov178, prov179, prov180, prov181, prov182, prov183, prov184, prov185, prov186, prov187, prov188, prov189, prov190, prov191, prov192, prov193, prov194, prov195, prov196, prov197, prov198, prov199, prov200, prov201, prov202, prov203, prov204, prov205, prov206, prov207, prov208, prov209, prov210, prov211, prov212, prov213, prov214, prov215, prov216, prov217, prov218, prov219, prov220, prov221, prov222, prov223, prov224, prov225, prov226, prov227, prov228, prov229, prov230, prov231, prov232, prov233, prov234, prov235, prov236, prov237, prov238, prov239, prov240, prov241, prov242, prov243, prov244, prov245, prov246, prov247, prov248, prov249, prov250, prov251, prov252, prov253, prov254, prov255, prov256, prov257, prov258, prov259, prov260, prov261, prov262, prov263, prov264, prov265, prov266, prov267, prov268, prov269, prov270, prov271, prov272, prov273, prov274, prov275, prov276, prov277, prov278, prov279, prov280, prov281, prov282, prov283, prov284, prov285, prov286, prov287, prov288, prov289, prov290, prov291, prov292, prov293, prov294, prov295, prov296, prov297, prov298, prov299
FROM
vertriebspartner
WHERE
(vpnummer like '".$_SESSION["avp"]."')";
$result = mysql_query ($sqla) or die(mysql_error());
$data = mysql_fetch_array ($result);
if ($VKZ == "07692") ($aprov = $data["prov02"] AND $Objekt = "Abenteuer und Reisen ");
if ($VKZ == "11100") ($aprov = $data["prov03"] AND $Objekt = "Aerokurier ");
if ($VKZ == "05766") ($aprov = $data["prov04"] AND $Objekt = "Alpin ");
if ($VKZ == "41049") ($aprov = $data["prov05"] AND $Objekt = "Amica ");
if ($VKZ == "01210") ($aprov = $data["prov06"] AND $Objekt = "Angelwoche ");
if ($VKZ == "01900") ($aprov = $data["prov07"] AND $Objekt = "Anna Spass an Handa. ");
if ($VKZ == "05247") ($aprov = $data["prov08"] AND $Objekt = "Architektur+Wohnen ");
if ($VKZ == "01084") ($aprov = $data["prov09"] AND $Objekt = "Art ");
if ($VKZ == "05085") ($aprov = $data["prov10"] AND $Objekt = "Audio ");
if ($VKZ == "03785") ($aprov = $data["prov11"] AND $Objekt = "Auf einen Blick ");
if ($VKZ == "69231") ($aprov = $data["prov12"] AND $Objekt = "Auf einen Blick tv. world ");
if ($VKZ == "01418") ($aprov = $data["prov13"] AND $Objekt = "Auto Motor Sport ");
if ($VKZ == "04333") ($aprov = $data["prov14"] AND $Objekt = "Autobild ");
if ($VKZ == "05337") ($aprov = $data["prov15"] AND $Objekt = "Auto Zeitung ");
if ($VKZ == "81615") ($aprov = $data["prov16"] AND $Objekt = "Baccara ");
if ($VKZ == "05351") ($aprov = $data["prov17"] AND $Objekt = "Bella ");
if ($VKZ == "19028") ($aprov = $data["prov18"] AND $Objekt = "Bellevue ");
if ($VKZ == "85565") ($aprov = $data["prov19"] AND $Objekt = "Benjamin Blümchen ");
if ($VKZ == "07606") ($aprov = $data["prov20"] AND $Objekt = "Berge ");
if ($VKZ == "81614") ($aprov = $data["prov21"] AND $Objekt = "Bianca ");
if ($VKZ == "10145") ($aprov = $data["prov22"] AND $Objekt = "Bike ");
if ($VKZ == "01128") ($aprov = $data["prov23"] AND $Objekt = "Bild am Sonntag ");
if ($VKZ == "02164") ($aprov = $data["prov24"] AND $Objekt = "Bild d. Wissenschaft ");
if ($VKZ == "06152") ($aprov = $data["prov25"] AND $Objekt = "Bild der Frau ");
if ($VKZ == "01778") ($aprov = $data["prov26"] AND $Objekt = "Bild und Funk ");
if ($VKZ == "81374") ($aprov = $data["prov27"] AND $Objekt = "Bild+Funk Spezial Rä ");
if ($VKZ == "03964") ($aprov = $data["prov28"] AND $Objekt = "Bildwoche ");
if ($VKZ == "01030") ($aprov = $data["prov29"] AND $Objekt = "Blinker ");
if ($VKZ == "07576") ($aprov = $data["prov30"] AND $Objekt = "Börse Online ");
if ($VKZ == "04862") ($aprov = $data["prov31"] AND $Objekt = "Boote ");
if ($VKZ == "01917") ($aprov = $data["prov32"] AND $Objekt = "Bravo ");
if ($VKZ == "05687") ($aprov = $data["prov33"] AND $Objekt = "Bravo Girl ");
if ($VKZ == "43162") ($aprov = $data["prov34"] AND $Objekt = "Bravo Screenfun ");
if ($VKZ == "81322") ($aprov = $data["prov35"] AND $Objekt = "Bravo Sport ");
if ($VKZ == "01940") ($aprov = $data["prov36"] AND $Objekt = "Brigitte ");
if ($VKZ == "11936") ($aprov = $data["prov37"] AND $Objekt = "Bummi ");
if ($VKZ == "02013") ($aprov = $data["prov38"] AND $Objekt = "Bunte ");
if ($VKZ == "02017") ($aprov = $data["prov39"] AND $Objekt = "Burda Modemagazin ");
if ($VKZ == "19000") ($aprov = $data["prov40"] AND $Objekt = "Bussi Bär ");
if ($VKZ == "02052") ($aprov = $data["prov41"] AND $Objekt = "Capital ");
if ($VKZ == "13119") ($aprov = $data["prov42"] AND $Objekt = "Caravaning ");
if ($VKZ == "01190") ($aprov = $data["prov43"] AND $Objekt = "Cash ");
if ($VKZ == "19154") ($aprov = $data["prov44"] AND $Objekt = "Chefarzt Dr. Holl ");
if ($VKZ == "05722") ($aprov = $data["prov45"] AND $Objekt = "Chip ");
if ($VKZ == "00019") ($aprov = $data["prov46"] AND $Objekt = "CHIP mit CHIP Digital ");
if ($VKZ == "57968") ($aprov = $data["prov47"] AND $Objekt = "CHIP mit DVD ");
if ($VKZ == "63920") ($aprov = $data["prov48"] AND $Objekt = "Ciciero ");
if ($VKZ == "57968") ($aprov = $data["prov49"] AND $Objekt = "Cinema");
if ($VKZ == "03598") ($aprov = $data["prov50"] AND $Objekt = "Color Foto ");
if ($VKZ == "02615") ($aprov = $data["prov51"] AND $Objekt = "Computerwoche ");
if ($VKZ == "12527") ($aprov = $data["prov52"] AND $Objekt = "Connect ");
if ($VKZ == "09102") ($aprov = $data["prov53"] AND $Objekt = "Cosmopolitan ");
if ($VKZ == "06809") ($aprov = $data["prov54"] AND $Objekt = "Coupe ");
if ($VKZ == "11108") ($aprov = $data["prov55"] AND $Objekt = "Damals ");
if ($VKZ == "01736") ($aprov = $data["prov56"] AND $Objekt = "Das Beste ");
if ($VKZ == "01907") ($aprov = $data["prov57"] AND $Objekt = "Das goldene Blatt ");
if ($VKZ == "07708") ($aprov = $data["prov58"] AND $Objekt = "Das Neue ");
if ($VKZ == "05134") ($aprov = $data["prov59"] AND $Objekt = "Das neue Blatt ");
if ($VKZ == "19156") ($aprov = $data["prov60"] AND $Objekt = "Der Bergdoktor ");
if ($VKZ == "01707") ($aprov = $data["prov61"] AND $Objekt = "Der Feinschmecker ");
if ($VKZ == "07007") ($aprov = $data["prov62"] AND $Objekt = "Der Spiegel ");
if ($VKZ == "06775") ($aprov = $data["prov63"] AND $Objekt = "Die Aktuelle ");
if ($VKZ == "19164") ($aprov = $data["prov64"] AND $Objekt = "Die g.Rätsel-Zeitung ");
if ($VKZ == "43410") ($aprov = $data["prov65"] AND $Objekt = "Die Maus ");
if ($VKZ == "48856") ($aprov = $data["prov66"] AND $Objekt = "Die neue Frau ");
if ($VKZ == "02310") ($aprov = $data["prov67"] AND $Objekt = "Die Tagespost ");
if ($VKZ == "07109") ($aprov = $data["prov68"] AND $Objekt = "Die Welt ");
if ($VKZ == "07451") ($aprov = $data["prov69"] AND $Objekt = "Die Zeit ");
if ($VKZ == "02953") ($aprov = $data["prov70"] AND $Objekt = "Die Zwei ");
if ($VKZ == "19151") ($aprov = $data["prov71"] AND $Objekt = "Dr. Stefan Frank ");
if ($VKZ == "48231") ($aprov = $data["prov72"] AND $Objekt = "E-Commerce ");
if ($VKZ == "01199") ($aprov = $data["prov73"] AND $Objekt = "Echo der Frau ");
if ($VKZ == "04164") ($aprov = $data["prov74"] AND $Objekt = "Ein Herz für Tiere ");
if ($VKZ == "02594") ($aprov = $data["prov75"] AND $Objekt = "Elektronik ");
if ($VKZ == "09492") ($aprov = $data["prov76"] AND $Objekt = "Elle ");
if ($VKZ == "06060") ($aprov = $data["prov77"] AND $Objekt = "Eltern ");
if ($VKZ == "41332") ($aprov = $data["prov78"] AND $Objekt = "Eltern for Family ");
if ($VKZ == "04155") ($aprov = $data["prov79"] AND $Objekt = "emma ");
if ($VKZ == "07660") ($aprov = $data["prov80"] AND $Objekt = "Essen und Trinken ");
if ($VKZ == "79850") ($aprov = $data["prov81"] AND $Objekt = "Euro am Sonntag ");
if ($VKZ == "81405") ($aprov = $data["prov82"] AND $Objekt = "Extra Reisen u Raten ");
if ($VKZ == "64865") ($aprov = $data["prov83"] AND $Objekt = "Familie und Co ");
if ($VKZ == "91180") ($aprov = $data["prov84"] AND $Objekt = "Fernfahrer ");
if ($VKZ == "03454") ($aprov = $data["prov85"] AND $Objekt = "Fernsehwoche ");
if ($VKZ == "69230") ($aprov = $data["prov86"] AND $Objekt = "Fernsehwoche TV World ");
if ($VKZ == "53399") ($aprov = $data["prov87"] AND $Objekt = "FFM For Him Magazine ");
if ($VKZ == "05222") ($aprov = $data["prov88"] AND $Objekt = "Finanztest ");
if ($VKZ == "07709") ($aprov = $data["prov89"] AND $Objekt = "Fisch und Fang ");
if ($VKZ == "03749") ($aprov = $data["prov90"] AND $Objekt = "Fit For Fun ");
if ($VKZ == "05621") ($aprov = $data["prov91"] AND $Objekt = "fliegermagazin ");
if ($VKZ == "08118") ($aprov = $data["prov92"] AND $Objekt = "Flora ");
if ($VKZ == "02881") ($aprov = $data["prov93"] AND $Objekt = "Flug Revue ");
if ($VKZ == "03894") ($aprov = $data["prov94"] AND $Objekt = "Fly and glide ");
if ($VKZ == "09314") ($aprov = $data["prov95"] AND $Objekt = "Focus ");
if ($VKZ == "65942") ($aprov = $data["prov96"] AND $Objekt = "Focus Schule ");
if ($VKZ == "51486") ($aprov = $data["prov97"] AND $Objekt = "Focus-Money ");
if ($VKZ == "05603") ($aprov = $data["prov98"] AND $Objekt = "fotoMAGAZIN ");
if ($VKZ == "02543") ($aprov = $data["prov99"] AND $Objekt = "Frau aktuell ");
if ($VKZ == "06313") ($aprov = $data["prov100"] AND $Objekt = "Frau im Leben ");
if ($VKZ == "08484") ($aprov = $data["prov101"] AND $Objekt = "Frau im Spiegel ");
if ($VKZ == "06327") ($aprov = $data["prov102"] AND $Objekt = "Frau mit Herz ");
if ($VKZ == "83698") ($aprov = $data["prov103"] AND $Objekt = "freizeit & rätsel-m. ");
if ($VKZ == "03034") ($aprov = $data["prov104"] AND $Objekt = "Freizeit Revue ");
if ($VKZ == "03875") ($aprov = $data["prov105"] AND $Objekt = "Freundin ");
if ($VKZ == "00023") ($aprov = $data["prov106"] AND $Objekt = "Freundin-Wellfit ");
if ($VKZ == "03081") ($aprov = $data["prov107"] AND $Objekt = "Für Sie ");
if ($VKZ == "19147") ($aprov = $data["prov108"] AND $Objekt = "Fürsten-Roman GS ");
if ($VKZ == "07843") ($aprov = $data["prov109"] AND $Objekt = "Funk Uhr ");
if ($VKZ == "03108") ($aprov = $data["prov110"] AND $Objekt = "Funkschau ");
if ($VKZ == "03120") ($aprov = $data["prov111"] AND $Objekt = "Fussballwoche ");
if ($VKZ == "55525") ($aprov = $data["prov112"] AND $Objekt = "Gärtnern leicht gem. ");
if ($VKZ == "09310") ($aprov = $data["prov113"] AND $Objekt = "Gala ");
if ($VKZ == "44085") ($aprov = $data["prov114"] AND $Objekt = "Geldidee ");
if ($VKZ == "03712") ($aprov = $data["prov115"] AND $Objekt = "Geliebte Katze ");
if ($VKZ == "02498") ($aprov = $data["prov116"] AND $Objekt = "Geo ");
if ($VKZ == "01334") ($aprov = $data["prov117"] AND $Objekt = "Geo Special ");
if ($VKZ == "09022") ($aprov = $data["prov118"] AND $Objekt = "Geo-Saison ");
if ($VKZ == "41719") ($aprov = $data["prov119"] AND $Objekt = "Geolino ");
if ($VKZ == "81413") ($aprov = $data["prov120"] AND $Objekt = "Gewinnen Sie ");
if ($VKZ == "81402") ($aprov = $data["prov121"] AND $Objekt = "Gewinnrätsel ");
if ($VKZ == "53763") ($aprov = $data["prov122"] AND $Objekt = "Glamour ");
if ($VKZ == "47245") ($aprov = $data["prov123"] AND $Objekt = "Glückspilz ");
if ($VKZ == "19047") ($aprov = $data["prov124"] AND $Objekt = "Glücksrätsel ");
if ($VKZ == "19036") ($aprov = $data["prov125"] AND $Objekt = "Glücksrevue ");
if ($VKZ == "04299") ($aprov = $data["prov126"] AND $Objekt = "Golf Journal ");
if ($VKZ == "03311") ($aprov = $data["prov127"] AND $Objekt = "GOLFmagazin ");
if ($VKZ == "44474") ($aprov = $data["prov128"] AND $Objekt = "Gong ");
if ($VKZ == "11734") ($aprov = $data["prov129"] AND $Objekt = "GQ ");
if ($VKZ == "11734") ($aprov = $data["prov130"] AND $Objekt = "Guter Rat ");
if ($VKZ == "03176") ($aprov = $data["prov131"] AND $Objekt = "Häuser ");
if ($VKZ == "65125") ($aprov = $data["prov132"] AND $Objekt = "Hed.-Courths-Mahl. 9 ");
if ($VKZ == "41310") ($aprov = $data["prov133"] AND $Objekt = "Heim und Welt ");
if ($VKZ == "19157") ($aprov = $data["prov134"] AND $Objekt = "Heimat-Roman ");
if ($VKZ == "85689") ($aprov = $data["prov135"] AND $Objekt = "Historical ");
if ($VKZ == "03769") ($aprov = $data["prov136"] AND $Objekt = "Hörzu ");
if ($VKZ == "04804") ($aprov = $data["prov137"] AND $Objekt = "Impulse ");
if ($VKZ == "68859") ($aprov = $data["prov138"] AND $Objekt = "IN das Starmagazin ");
if ($VKZ == "69845") ($aprov = $data["prov139"] AND $Objekt = "In Touch ");
if ($VKZ == "48815") ($aprov = $data["prov140"] AND $Objekt = "Indstyle ");
if ($VKZ == "14334") ($aprov = $data["prov141"] AND $Objekt = "Internet Profession. ");
if ($VKZ == "19138") ($aprov = $data["prov142"] AND $Objekt = "Jerry Cotton 1 ");
if ($VKZ == "19142") ($aprov = $data["prov143"] AND $Objekt = "John Sinclar I ");
if ($VKZ == "81661") ($aprov = $data["prov144"] AND $Objekt = "Julia ");
if ($VKZ == "73243") ($aprov = $data["prov145"] AND $Objekt = "Julia Ärtze zum Verl ");
if ($VKZ == "01367") ($aprov = $data["prov146"] AND $Objekt = "Kicker ");
if ($VKZ == "08057") ($aprov = $data["prov147"] AND $Objekt = "Kochen und Geniessen ");
if ($VKZ == "84351") ($aprov = $data["prov148"] AND $Objekt = "Kraut & Rüben ");
if ($VKZ == "99001") ($aprov = $data["prov149"] AND $Objekt = "Landser ");
if ($VKZ == "40149") ($aprov = $data["prov150"] AND $Objekt = "Lassiter 1 ");
if ($VKZ == "04453") ($aprov = $data["prov151"] AND $Objekt = "Lastauto-Omnibus ");
if ($VKZ == "81328") ($aprov = $data["prov152"] AND $Objekt = "Laura ");
if ($VKZ == "48969") ($aprov = $data["prov153"] AND $Objekt = "Laura Wohnen Kreativ ");
if ($VKZ == "50237") ($aprov = $data["prov154"] AND $Objekt = "Lea ");
if ($VKZ == "04459") ($aprov = $data["prov155"] AND $Objekt = "Leben und Erziehen ");
if ($VKZ == "00512") ($aprov = $data["prov156"] AND $Objekt = "Leben und Glauben ");
if ($VKZ == "80237") ($aprov = $data["prov157"] AND $Objekt = "Lena ");
if ($VKZ == "48754") ($aprov = $data["prov158"] AND $Objekt = "Lenz ");
if ($VKZ == "09354") ($aprov = $data["prov159"] AND $Objekt = "Lisa ");
if ($VKZ == "50369") ($aprov = $data["prov160"] AND $Objekt = "Lisa Blumen & Pflanz ");
if ($VKZ == "43532") ($aprov = $data["prov161"] AND $Objekt = "Lisa Kochen u.Backen ");
if ($VKZ == "45643") ($aprov = $data["prov162"] AND $Objekt = "Lisa Wohnen u.Dekor. ");
if ($VKZ == "91400") ($aprov = $data["prov163"] AND $Objekt = "Lissy ");
if ($VKZ == "52913") ($aprov = $data["prov164"] AND $Objekt = "Living at home ");
if ($VKZ == "19008") ($aprov = $data["prov165"] AND $Objekt = "Lustiges Taschenbuch ");
if ($VKZ == "04513") ($aprov = $data["prov166"] AND $Objekt = "Mäch mal Pause ");
if ($VKZ == "04579") ($aprov = $data["prov167"] AND $Objekt = "Madame ");
if ($VKZ == "09116") ($aprov = $data["prov168"] AND $Objekt = "Mädchen ");
if ($VKZ == "30066") ($aprov = $data["prov169"] AND $Objekt = "Mami ");
if ($VKZ == "06634") ($aprov = $data["prov170"] AND $Objekt = "Manager Magazin ");
if ($VKZ == "64114") ($aprov = $data["prov171"] AND $Objekt = "Matador ");
if ($VKZ == "06519") ($aprov = $data["prov172"] AND $Objekt = "Max ");
if ($VKZ == "08345") ($aprov = $data["prov173"] AND $Objekt = "Maxi");
if ($VKZ == "06355") ($aprov = $data["prov174"] AND $Objekt = "Mein schöner Garten ");
if ($VKZ == "11915") ($aprov = $data["prov175"] AND $Objekt = "Meine Melodie ");
if ($VKZ == "41079") ($aprov = $data["prov176"] AND $Objekt = "Men´s Health ");
if ($VKZ == "04701") ($aprov = $data["prov177"] AND $Objekt = "Merian ");
if ($VKZ == "84323") ($aprov = $data["prov178"] AND $Objekt = "Metal Hammer ");
if ($VKZ == "19002") ($aprov = $data["prov179"] AND $Objekt = "Micky Maus ");
if ($VKZ == "91217") ($aprov = $data["prov180"] AND $Objekt = "Mini fuer Alle ");
if ($VKZ == "06525") ($aprov = $data["prov181"] AND $Objekt = "Motor Klassik ");
if ($VKZ == "04973") ($aprov = $data["prov182"] AND $Objekt = "Motorrad ");
if ($VKZ == "05259") ($aprov = $data["prov183"] AND $Objekt = "Motorsport Aktuell ");
if ($VKZ == "90767") ($aprov = $data["prov184"] AND $Objekt = "Mountain Bike ");
if ($VKZ == "09101") ($aprov = $data["prov185"] AND $Objekt = "Musikexpress ");
if ($VKZ == "83869") ($aprov = $data["prov186"] AND $Objekt = "My Lady ");
if ($VKZ == "80427") ($aprov = $data["prov187"] AND $Objekt = "Mystery ");
if ($VKZ == "50690") ($aprov = $data["prov188"] AND $Objekt = "National Geographic ");
if ($VKZ == "07114") ($aprov = $data["prov189"] AND $Objekt = "Natur und Kosmos ");
if ($VKZ == "61997") ($aprov = $data["prov190"] AND $Objekt = "Neon ");
if ($VKZ == "01081") ($aprov = $data["prov191"] AND $Objekt = "Neue Gesundheit ");
if ($VKZ == "08223") ($aprov = $data["prov192"] AND $Objekt = "Neue Post ");
if ($VKZ == "07111") ($aprov = $data["prov193"] AND $Objekt = "Neue Welt ");
if ($VKZ == "19152") ($aprov = $data["prov194"] AND $Objekt = "Notärtzin A. Bergen ");
if ($VKZ == "77031") ($aprov = $data["prov195"] AND $Objekt = "ÔK! ");
if ($VKZ == "06311") ($aprov = $data["prov196"] AND $Objekt = "ÖKO Test ");
if ($VKZ == "06022") ($aprov = $data["prov197"] AND $Objekt = "Off Road ");
if ($VKZ == "03496") ($aprov = $data["prov198"] AND $Objekt = "P S ");
if ($VKZ == "05844") ($aprov = $data["prov199"] AND $Objekt = "P.M. ");
if ($VKZ == "90624") ($aprov = $data["prov200"] AND $Objekt = "P.M. History ");
if ($VKZ == "53049") ($aprov = $data["prov201"] AND $Objekt = "P.M. Fragen&Antworten ");
if ($VKZ == "03801") ($aprov = $data["prov202"] AND $Objekt = "Partner Hund ");
if ($VKZ == "50027") ($aprov = $data["prov203"] AND $Objekt = "PC Action DVD ");
if ($VKZ == "63381") ($aprov = $data["prov204"] AND $Objekt = "PC Action-Ab-18-Edit ");
if ($VKZ == "12782") ($aprov = $data["prov205"] AND $Objekt = "PC Games DVD ");
if ($VKZ == "63379") ($aprov = $data["prov206"] AND $Objekt = "PC Games-Ab-18-Edit ");
if ($VKZ == "99010") ($aprov = $data["prov207"] AND $Objekt = "PC Magazin Cl. DVD P ");
if ($VKZ == "08981") ($aprov = $data["prov208"] AND $Objekt = "PC Magazin Classic D ");
if ($VKZ == "99111") ($aprov = $data["prov209"] AND $Objekt = "PC Magazin DVD P.XXL ");
if ($VKZ == "11646") ($aprov = $data["prov210"] AND $Objekt = "PC Professionell ");
if ($VKZ == "91646") ($aprov = $data["prov211"] AND $Objekt = "PC Professionell DVD ");
if ($VKZ == "00704") ($aprov = $data["prov212"] AND $Objekt = "PC Welt DVD ");
if ($VKZ == "12569") ($aprov = $data["prov213"] AND $Objekt = "PCgo Classic DVD ");
if ($VKZ == "22345") ($aprov = $data["prov214"] AND $Objekt = "PCgo Classic DVD Pr. ");
if ($VKZ == "22346") ($aprov = $data["prov215"] AND $Objekt = "PCgo DVD Premium XXL ");
if ($VKZ == "99002") ($aprov = $data["prov216"] AND $Objekt = "Perry Rhodan 1 ");
if ($VKZ == "02833") ($aprov = $data["prov217"] AND $Objekt = "Petra ");
if ($VKZ == "06793") ($aprov = $data["prov218"] AND $Objekt = "Playboy ");
if ($VKZ == "09117") ($aprov = $data["prov219"] AND $Objekt = "Popcorn ");
if ($VKZ == "05670") ($aprov = $data["prov220"] AND $Objekt = "Praline ");
if ($VKZ == "19141") ($aprov = $data["prov221"] AND $Objekt = "Professor Zamorra ");
if ($VKZ == "02956") ($aprov = $data["prov222"] AND $Objekt = "Promobil ");
if ($VKZ == "81411") ($aprov = $data["prov223"] AND $Objekt = "Rätsel & Freizeit ");
if ($VKZ == "49279") ($aprov = $data["prov224"] AND $Objekt = "Rätsel mit Pfiff ");
if ($VKZ == "19159") ($aprov = $data["prov225"] AND $Objekt = "Rätsel Zeitung ");
if ($VKZ == "40889") ($aprov = $data["prov226"] AND $Objekt = "Rätselkönig ");
if ($VKZ == "30050") ($aprov = $data["prov227"] AND $Objekt = "Rätselmühle ");
if ($VKZ == "05774") ($aprov = $data["prov228"] AND $Objekt = "Ratgeber ");
if ($VKZ == "05832") ($aprov = $data["prov229"] AND $Objekt = "Reiter Revue ");
if ($VKZ == "05151") ($aprov = $data["prov230"] AND $Objekt = "Revue ");
if ($VKZ == "06080") ($aprov = $data["prov231"] AND $Objekt = "Rezepte mit Pfiff ");
if ($VKZ == "05889") ($aprov = $data["prov232"] AND $Objekt = "Rheinischer Merkur ");
if ($VKZ == "81613") ($aprov = $data["prov233"] AND $Objekt = "Romana ");
if ($VKZ == "85302") ($aprov = $data["prov234"] AND $Objekt = "Sabrina ");
if ($VKZ == "06141") ($aprov = $data["prov235"] AND $Objekt = "Schöner Wohnen ");
if ($VKZ == "04515") ($aprov = $data["prov236"] AND $Objekt = "Selbermachen ");
if ($VKZ == "06274") ($aprov = $data["prov237"] AND $Objekt = "Selbst ist der Mann ");
if ($VKZ == "47900") ($aprov = $data["prov238"] AND $Objekt = "Shape ");
if ($VKZ == "03574") ($aprov = $data["prov239"] AND $Objekt = "Sieben Tage ");
if ($VKZ == "19146") ($aprov = $data["prov240"] AND $Objekt = "Silvia-Exklusiv ");
if ($VKZ == "05431") ($aprov = $data["prov241"] AND $Objekt = "Skimagazin ");
if ($VKZ == "08001") ($aprov = $data["prov242"] AND $Objekt = "SP Nachrichten ");
if ($VKZ == "06179") ($aprov = $data["prov243"] AND $Objekt = "Spektrum ");
if ($VKZ == "19162") ($aprov = $data["prov244"] AND $Objekt = "Spezial-Rätsel ");
if ($VKZ == "25413") ($aprov = $data["prov245"] AND $Objekt = "Spezial-Rätsel gS ");
if ($VKZ == "01485") ($aprov = $data["prov246"] AND $Objekt = "Spielen und Lernen ");
if ($VKZ == "03883") ($aprov = $data["prov247"] AND $Objekt = "Sport Auto ");
if ($VKZ == "04186") ($aprov = $data["prov248"] AND $Objekt = "Sportbild ");
if ($VKZ == "06058") ($aprov = $data["prov249"] AND $Objekt = "St. Georg ");
if ($VKZ == "06951") ($aprov = $data["prov250"] AND $Objekt = "Stereoplay ");
if ($VKZ == "08041") ($aprov = $data["prov251"] AND $Objekt = "Stern ");
if ($VKZ == "83322") ($aprov = $data["prov252"] AND $Objekt = "Super TV m. Premiere ");
if ($VKZ == "09391") ($aprov = $data["prov253"] AND $Objekt = "Superillu ");
if ($VKZ == "67186") ($aprov = $data["prov254"] AND $Objekt = "SUPERillu ABOplus ");
if ($VKZ == "04541") ($aprov = $data["prov255"] AND $Objekt = "Surf Magazin ");
if ($VKZ == "02123") ($aprov = $data["prov256"] AND $Objekt = "tauchen ");
if ($VKZ == "02109") ($aprov = $data["prov257"] AND $Objekt = "tennis magazin ");
if ($VKZ == "01100") ($aprov = $data["prov258"] AND $Objekt = "Test ");
if ($VKZ == "04111") ($aprov = $data["prov259"] AND $Objekt = "Tina ");
if ($VKZ == "44164") ($aprov = $data["prov260"] AND $Objekt = "Tina Koch & Backidee ");
if ($VKZ == "68275") ($aprov = $data["prov261"] AND $Objekt = "Tomorrow ");
if ($VKZ == "01593") ($aprov = $data["prov262"] AND $Objekt = "Tour ");
if ($VKZ == "02843") ($aprov = $data["prov263"] AND $Objekt = "Trucker ");
if ($VKZ == "03784") ($aprov = $data["prov264"] AND $Objekt = "TV Hören und Sehen ");
if ($VKZ == "69229") ($aprov = $data["prov265"] AND $Objekt = "TV Hören und Sehen tv. world ");
if ($VKZ == "01060") ($aprov = $data["prov266"] AND $Objekt = "TV Movie ");
if ($VKZ == "64611") ($aprov = $data["prov267"] AND $Objekt = "TV Movie mit DVD ");
if ($VKZ == "78697") ($aprov = $data["prov268"] AND $Objekt = "TV Movie Digital ");
if ($VKZ == "79286") ($aprov = $data["prov269"] AND $Objekt = "TV Movie Digital m. DVD ");
if ($VKZ == "11078") ($aprov = $data["prov270"] AND $Objekt = "TV Neu ");
if ($VKZ == "10545") ($aprov = $data["prov271"] AND $Objekt = "TV Spielfilm ");
if ($VKZ == "20545") ($aprov = $data["prov272"] AND $Objekt = "TV Spielfilm XXL ");
if ($VKZ == "40243") ($aprov = $data["prov273"] AND $Objekt = "TV Today ");
if ($VKZ == "05047") ($aprov = $data["prov274"] AND $Objekt = "Unterwasser ");
if ($VKZ == "04777") ($aprov = $data["prov275"] AND $Objekt = "Video ");
if ($VKZ == "68204") ($aprov = $data["prov276"] AND $Objekt = "View ");
if ($VKZ == "02873") ($aprov = $data["prov277"] AND $Objekt = "Vital ");
if ($VKZ == "06598") ($aprov = $data["prov278"] AND $Objekt = "VIVA ");
if ($VKZ == "09302") ($aprov = $data["prov279"] AND $Objekt = "Vogue ");
if ($VKZ == "07123") ($aprov = $data["prov280"] AND $Objekt = "Welt am Sonntag ");
if ($VKZ == "55112") ($aprov = $data["prov281"] AND $Objekt = "Welt der Frau ");
if ($VKZ == "19009") ($aprov = $data["prov282"] AND $Objekt = "Wendy ");
if ($VKZ == "40147") ($aprov = $data["prov283"] AND $Objekt = "Western Bestseller ");
if ($VKZ == "07329") ($aprov = $data["prov284"] AND $Objekt = "Wild und Hund ");
if ($VKZ == "10718") ($aprov = $data["prov285"] AND $Objekt = "Wirtschaftswoche");
if ($VKZ == "50607") ($aprov = $data["prov286"] AND $Objekt = "Woche der Frau ");
if ($VKZ == "50370") ($aprov = $data["prov287"] AND $Objekt = "Wohnen & Garten ");
if ($VKZ == "07659") ($aprov = $data["prov288"] AND $Objekt = "Wohnidee ");
if ($VKZ == "59798") ($aprov = $data["prov289"] AND $Objekt = "Woman ");
if ($VKZ == "30052") ($aprov = $data["prov290"] AND $Objekt = "Wort-Suchspiel ");
if ($VKZ == "07440") ($aprov = $data["prov291"] AND $Objekt = "Yacht ");
if ($VKZ == "04936") ($aprov = $data["prov292"] AND $Objekt = "Zuhause Wohnen ");
if ($VKZ == "10548") ($aprov = $data["prov293"] AND $Objekt = "€uro ");
// für anderen Abo Code //
if ($VKZ == "03769" AND $Abocode == "JT0032") ($aprov = $data["prov294"] AND $Objekt = "Hörzu ");
if ($VKZ == "09314" AND $Abocode == "JT0032") ($aprov = $data["prov295"] AND $Objekt = "Focus ");
if ($VKZ == "09310" AND $Abocode == "JT0032") ($aprov = $data["prov296"] AND $Objekt = "Gala ");
if ($VKZ == "01199" AND $Abocode == "JT0032") ($aprov = $data["prov297"] AND $Objekt = "Echo der Frau ");
if ($VKZ == "02543" AND $Abocode == "JT0032") ($aprov = $data["prov298"] AND $Objekt = "Frau Aktuell ");
if ($VKZ == "07111" AND $Abocode == "JT0032") ($aprov = $data["prov299"] AND $Objekt = "Neue Welt ");
if ($Abocode == "JT0005" ) ($aprov = "30");
if ($Abocode == "JT0032" ) ($Orga_Nummer = "4464");
if ($Abocode == "JT0035" ) ($Orga_Nummer = "8749");
if ($Abocode == "JT0037" ) ($Orga_Nummer = "8749");
$sql = "UPDATE auftrag1 SET
`Orga_Nummer`='$Orga_Nummer', `aabocode`='$aabocode', `abemerkungen`='".$_POST['abemerkungen']."', `aVKZ`='$aVKZ', `aagent`='$aagent', `datum`='".$_POST['datum']."', `RE_ANREDE`='".$_POST['RE_ANREDE']."', `RE_NACHNAME`='".$_POST['RE_NACHNAME']."', `RE_VORNAME`='".$_POST['RE_VORNAME']."', `GEB_Datum`='".$_POST['GEB_Datum']."', `RE_Zusatz`='".$_POST['RE_Zusatz']."', `RE_STRASSE`='".$_POST['RE_STRASSE']."', `RE_PLZ`='".$_POST['RE_PLZ']."', `RE_STADT`='".$_POST['RE_STADT']."', `RE_LAND`='".$_POST['RE_LAND']."', `RE_TEL`='".$_POST['RE_TEL']."', `Fremdkunden_ID2`='".$_POST['Fremdkunden_ID2']."', `RE_FAX`='".$_POST['RE_FAX']."', `RE_MAIL`='".$_POST['RE_MAIL']."', `LA_ANREDE`='".$_POST['LA_ANREDE']."', `LA_NACHNAME`='".$_POST['LA_NACHNAME']."', `LA_VORNAME`='".$_POST['LA_VORNAME']."', `LA_Zusatz`='".$_POST['LA_Zusatz']."', `LA_STRASSE`='".$_POST['LA_STRASSE']."', `LA_PLZ`='".$_POST['LA_PLZ']."', `LA_STADT`='".$_POST['LA_STADT']."', `LA_LAND`='".$_POST['LA_LAND']."', `LA_TEL`='".$_POST['LA_TEL']."', `LA_FAX`='".$_POST['LA_FAX']."', `LA_MAIL`='".$_POST['LA_MAIL']."', `Kontonummer`='".$_POST['Kontonummer']."', `BLZ`='".$_POST['BLZ']."', `Bank`='".$_POST['Bank']."', `bemerkungen`='".$_POST['bemerkungen']."', `Zahlungsart`='".$_POST['Zahlungsart']."', `Zahlungsrhythmus`='".$_POST['Zahlungsrhythmus']."', `Abocode`='$Abocode', `VKZ`='$VKZ', `aprov`='$aprov', `Objekt`='$Objekt'
WHERE
(RE_TEL like '".$_SESSION["user_telefon"]."')";
echo $sql;
mysql_query($sql) or die (mysql_error());
echo "<!-- Beginn Überschrift -->\n";
echo "\n";
echo "<body bgcolor=#0F0F0F>\n";
echo "<h1 align=left><font color=#FFFFFF>\n";
echo "Die Änderungen wurden erfolgreich gespeichert.\n";
echo "\n";
echo "<!-- Ende Überschrift -->\n";
echo "\n";
echo "<!--Beginn Haupttext-->\n";
echo "\n";
echo "<form name=\"my_form\" method=\"get\" action=\"startseite.php\">\n";
echo "<input type=\"submit\" name=\"submit\" value=\"Zurück\">\n";
echo "</form>\n";
echo "</form>\n";
echo "<p>\n";
};
hier der sql
Notice: Undefined index: Objekt in /var/www/web2/html/wasserman/b/rootcheckbearbeitung.php on line 710
UPDATE auftrag1 SET `Orga_Nummer`='8749', `aabocode`='JT0032', `abemerkungen`='', `aVKZ`='01199', `aagent`='root', `datum`='03.06.2009', `RE_ANREDE`='2', `RE_NACHNAME`='Klostermann', `RE_VORNAME`='Waltraud', `GEB_Datum`='60834', `RE_Zusatz`='', `RE_STRASSE`='Detmolderstr 210', `RE_PLZ`='33604', `RE_STADT`='Bielefeld', `RE_LAND`='Deutschland', `RE_TEL`='521131272', `Fremdkunden_ID2`='', `RE_FAX`='', `RE_MAIL`='', `LA_ANREDE`='', `LA_NACHNAME`='', `LA_VORNAME`='', `LA_Zusatz`='', `LA_STRASSE`='', `LA_PLZ`='', `LA_STADT`='', `LA_LAND`='', `LA_TEL`='', `LA_FAX`='', `LA_MAIL`='', `Kontonummer`='74533761', `BLZ`='48050161', `Bank`='Sparkasse', `bemerkungen`='', `Zahlungsart`='3', `Zahlungsrhythmus`='5', `Abocode`='JT0035', `VKZ`='01900', `aprov`='0', `Objekt`='' WHERE (RE_TEL like '521131272')
Line 710 ist die Line vom Mysql Query Objekt steht ganz am Ende....
Hab schon alles mögliche probiert...
Zumal ja die Variable VKZ richtig gespeichert wird und somit das Objekt auch da sein müsste.
Hoffe es weiß jemand Rat
Gruss
Marcel |
24.06.2009, 21:47
Ähnliche Themen 
![[Erledigt] Variable wird nicht übernommen](http://www.php.de/iconimages/php-tipps-2009/erledigt-variable-wird-nicht-uebernommen_ltr.gif)
