Tjekke SQL query

har du en ide om hvor fejlen opstår i koden?

Jeg får følgende fejl: Undefined variable: toto    . Fejlen ligger i følgende(linie 103):

if ($data1['istoto'] == 1) {                           
102            for ($i=0; $i<sizeof($m_id); $i++) {           
103                $tt = $toto[$i];
104                $result = dbquery("select * from ".$db_prefix."wst_results where league_id=$lid and matchday_id=$md and match_id=$m_id[$i]");
105                $data = dbarray($result);

Samt følgenden fejl i linie 34 Undefined offset: 0:

if (!isset($data['team1']))
34                if (isNum($tipp1[$i]) && isNum($tipp2[$i]))
35                    $result = dbquery("insert into ".$db_prefix."wst_results(league_id, matchday_id, match_id, team1, team2) values($lid, $md, $m_id[$i],
                    $tipp1[$i], $tipp2[$i])");

første fejl påstår at der ikke findes en variabel der hedder $toto - er der det?

prøv at drop linjeskiftet i slutningen af linje 35 i anden fejl (mellem $m_id[$i], og $tipp1[$i])

Hej. Altså hvor skal den være ? I databsen eller hvad?

Det virker stadig ikke med uden mellemrummet..
Jeg har kopireret præcis de samme filer og database indholdet, så alt det samme er der. Det ligner os hinanden 100%, men det eneste er den fejl der..

den skal være før de linjer du poster...

Filen ser således ud:

1    <?php
2    /*-------------------------------------------------------+
3    | PHP-Fusion Content Management System
4    | Copyright © 2002 - 2008 Nick Jones
5    | http://www.php-fusion.co.uk/
6    +--------------------------------------------------------+
7    | Filename: league_admin.php
8    | Author: ChSchuetz
9    +--------------------------------------------------------+
10    | This program is released as free software under the
11    | Affero GPL license. You can redistribute it and/or
12    | modify it under the terms of this license which you
13    | can read by viewing the included agpl.txt or online
14    | at www.gnu.org/licenses/agpl.html. Removal of this
15    | copyright header is strictly prohibited without
16    | written permission from the original author(s).
17    +--------------------------------------------------------*/
18    require_once "../../../maincore.php";
19    require_once THEMES."templates/admin_header.php";
20    include INFUSIONS."wir_sind_tippspiel/infusion_db.php";
21   
22    include "league_admin_menu.php";
23   
24    if (!checkrights("WST")) { redirect("../index.php"); }
25   
26    // Check if locale file is available matching the current site locale setting.
27    if (file_exists(INFUSIONS."wir_sind_tippspiel/locale/".$settings['locale'].".php")) {
28        // Load the locale file matching the current site locale setting.
29        include INFUSIONS."wir_sind_tippspiel/locale/".$settings['locale'].".php";
30    } else {
31        // Load the infusion's default locale file.
32        include INFUSIONS."wir_sind_tippspiel/locale/German.php";
33    }
34   
35    echo "<table width='100%'><tr><td valign='top' align='center'>";
36   
37    $bullet = "<img src='".THEME."images/bullet.gif' alt='' border='0'>";
38    $bulletb = "<img src='".THEME."images/bulletb.gif' alt='' border='0'>";
39   
40    $lid = (isset($_GET['lid']) && isNum($_GET['lid'])) ? $_GET['lid'] : 0;
41    $md = (isset($_GET['md']) && isNum($_GET['md'])) ? $_GET['md'] : 0;
42    $action = isset($_GET['act']) ? stripinput($_GET['act']) : "";
43   
44    $result = dbquery("select * from ".$db_prefix."wst_leagues where league_id=$lid");
45    $data = dbarray($result);
46   
47    if ($action == "") echo '<h2>'.$data['league_name'].'</h2>';
48    if ($action == "entertipps") echo '<h2>'.$data['league_name'].' - '.$locale['wst278'].'</h2>';
49    if ($action == "enterbonus") echo '<h2>'.$data['league_name'].' - '.$locale['wst278'].'</h2>';
50    if ($action == "alo_teams") echo '<h2>'.$data['league_name'].' - '.$locale['wst154'].'</h2>';
51    if ($action == "admin_fixtures") echo '<h2>'.$data['league_name'].' - '.$locale['wst156'].'</h2>';
52    if ($action == "admin_results") echo '<h2>'.$data['league_name'].' - '.$locale['wst157'].'</h2>';
53    if ($action == "edt_details") echo '<h2>'.$data['league_name'].' - '.$locale['wst241'].'</h2>'; //
54    if ($action == "edt_tickerevents") echo '<h2>'.$data['league_name'].' - '.$locale['wst245'].'</h2>'; //
55    if ($action == "credits") echo '<h2>'.$locale['wst100'].' - '.$locale['wst337'].'</h2>';
56   
57    if ($action == "credits") {
58        include("credits.php");
59    }
60   
61    if ($action == "edt_details") {
62        include("adm_details.php");
63    }
64   
65    if ($action == "alo_teams") {   
66        include("alo_teams.php");
67    }
68   
69    if ($action == "addm") {
70        $result_lop = dbarray(dbquery("select * from ".$db_prefix."wst_leagues where league_id=$lid"));
71        $result = dbquery("select max(match_id) as maxm, matchday_datestamp as date, matchday_descr from ".$db_prefix."wst_matchdays where
        league_id=$lid and matchday_id=$md group by matchday_id");
72        $data = dbarray($result);
73        $_date1 = $data['date'];
74        $descr = $data['matchday_descr'];
75        if (isset($data['maxm'])) $nextm = $data['maxm']+1; else $nextm=0;
76            if ($result_lop['league_type'] == 0)
77                $result = dbquery("INSERT INTO ".$db_prefix."wst_matchdays(league_id, matchday_id, match_id, matchday_datestamp) VALUES($lid, $md, $nextm,
                '$_date1')");
78            else
79                $result = dbquery("INSERT INTO ".$db_prefix."wst_matchdays(league_id, matchday_id, matchday_descr, match_id, matchday_datestamp) VALUES($lid,
                $md, '$descr', $nextm, '$_date1')");
80        $url = "league_admin.php?act=admin_fixtures&lid=$lid&md=$md";
81        redirect($url);
82    }
83   
84    if ($action == "delm") {
85        $mid = (isset($_GET['mid']) && isNum($_GET['mid'])) ? $_GET['mid'] : 0;
86        $md = (isset($_GET['md']) && isNum($_GET['md'])) ? $_GET['md'] : 0;
87        $lid = (isset($_GET['lid']) && isNum($_GET['lid'])) ? $_GET['lid'] : 0;
88        $result = dbquery("delete from ".$db_prefix."wst_matchdays where league_id=$lid and matchday_id=$md and match_id=$mid");
89        $result = dbquery("delete from ".$db_prefix."wst_teampoints where league_id=$lid and matchday_id=$md and match_id=$mid");
90        $url = "league_admin.php?act=admin_fixtures&lid=$lid&md=$md";
91        redirect($url);
92    }
93   
94   
95    if ($action == "admin_fixtures") {       
96        include("adm_fixtures.php");   
97    }
98   
99   
100    if ($action == "edt_tickerevents") {       
101        include("adm_tickerevents.php");   
102    }
103   
104    if ($action == "admin_results") {
105        include("adm_results.php");   
106    }
107   
108   
109    if ($action == "calc_allpoints") {
110        $l = (isset($_GET['lid']) && isNum($_GET['lid'])) ? $_GET['lid'] : 0;
111        $result_config = dbquery("select * from ".$db_prefix."wst_config as A left join ".$db_prefix."wst_leagues as B on A.league_id=B.league_id where
        A.league_id=$lid");
112        $data_config = dbarray($result_config);
113        $tendenz = $data_config['config_tendenz'];
114        $richtig = $data_config['config_richtig'];
115        $diff_act = $data_config['config_diff_active'];
116        $bonus_act = $data_config['config_bonus_active'];
117        $funfer_act = $data_config['config_funfer_active'];
118        $diff = $data_config['config_diff'];
119        $funfer = $data_config['config_funfer'];
120        $istoto = $data_config['istoto'];
121        $bonus = $data_config['config_bonus'];
122        $diff_tie = $data_config['config_diff_tie'];
123       
124        $l = (isset($_GET['lid']) && isNum($_GET['lid'])) ? $_GET['lid'] : 0;
125        $m_d = (isset($_GET['md']) && isNum($_GET['md'])) ? $_GET['md'] : 0;
126        $mid = (isset($_GET['mid']) && isNum($_GET['mid'])) ? $_GET['mid'] : 0;
127        $result_results = dbquery("select * from ".$db_prefix."wst_results where league_id=$l and matchday_id=$m_d and calc=0");
128        while($data_results = dbarray($result_results)) {
129            $lid = $data_results['league_id'];
130            $md = $data_results['matchday_id'];
131            $mid = $data_results['match_id'];
132            include("calc_points.php");   
133        }
134        $url = "league_admin.php?act=admin_results&lid=$l&md=$m_d";
135        redirect($url);
136    }
137   
138   
139    if ($action == "calc_points") {
140        $result_config = dbquery("select * from ".$db_prefix."wst_config as A left join ".$db_prefix."wst_leagues as B on A.league_id=B.league_id where
        A.league_id=$lid");
141        $data_config = dbarray($result_config);
142        $tendenz = $data_config['config_tendenz'];
143        $richtig = $data_config['config_richtig'];
144        $diff_act = $data_config['config_diff_active'];
145        $bonus_act = $data_config['config_bonus_active'];
146        $funfer_act = $data_config['config_funfer_active'];
147        $diff = $data_config['config_diff'];
148        $funfer = $data_config['config_funfer'];
149        $istoto = $data_config['istoto'];
150        $bonus = $data_config['config_bonus'];
151        $diff_tie = $data_config['config_diff_tie'];
152        include("calc_points.php");   
153    }
154   
155   
156    if ($action == "del_result") {
157        $lid = (isset($_GET['lid']) && isNum($_GET['lid'])) ? $_GET['lid'] : 0;
158        $md = (isset($_GET['md']) && isNum($_GET['md'])) ? $_GET['md'] : 0;
159        $mid = (isset($_GET['mid']) && isNum($_GET['mid'])) ? $_GET['mid'] : 0;
160        $result = dbquery("delete from ".$db_prefix."wst_results where league_id=$lid and matchday_id=$md and match_id=$mid");
161        $result = dbquery("delete from ".$db_prefix."wst_userpoints where league_id=$lid and matchday_id=$md and match_id=$mid");
162        $result = dbquery("delete from ".$db_prefix."wst_teampoints where league_id=$lid and matchday_id=$md and match_id=$mid");
163        $result = dbquery("delete from ".$db_prefix."wst_ticker where league_id=$lid and matchday_id=$md and match_id=$mid");
164        $url = "league_admin.php?act=admin_results&lid=$lid&md=$md";
165        redirect($url);   
166    }
167   
168    if ($action == "entertipps") {
169        include("adm_tipps.php");
170    }
171   
172   
173    if ($action == "enterbonus") {
174        include("adm_bonus.php");
175    }
176   
177   
178    if (!isset($action) || $action=='') {
179        include("overview.php");
180    }
181   
182    $result = dbquery("select * from ".$db_prefix."wst_leagues where league_id=$lid");
183    $data = dbarray($result);   
184    $l_name = $data['league_name'];
185    echo "</td><td align='right'>";
186    rightside($lid, $l_name);
187    echo "</td></tr></table>";
188    require_once THEMES."templates/footer.php";
189    ?>

Forkerte fil..

Det her er den rigtige..

<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright © 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: adm_results.php
| Author: ChSchuetz
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!checkrights("WST")) { redirect("../index.php"); }

if (isset($_POST['save']) && $_POST['save'] == TRUE) {   
    $result1 = dbquery("select * from ".$db_prefix."wst_leagues where league_id=$lid");
    $data1 = dbarray($result1);   
    $md = isset($_POST['match']) ? $_POST['match'] : 0;
    $m_id = isset($_POST['m_id']) ? $_POST['m_id'] : array();
    $tipp1 = isset($_POST['tipp1']) ? $_POST['tipp1'] : array();
    $tipp2 = isset($_POST['tipp2']) ? $_POST['tipp2'] : array();
    $tid = isset($_POST['tid']) ? $_POST['tid'] : array();
    $tid2 = isset($_POST['tid2']) ? $_POST['tid2'] : array();
    for ($i=0; $i<sizeof($m_id); $i++) {
        $result = dbquery("select * from ".$db_prefix."wst_results where league_id=$lid and matchday_id=$md and match_id=$m_id[$i]");
        $data = dbarray($result);
               
        if (!isset($data['team1']))
            if (isnum($tipp1[$i]) && isnum($tipp2[$i]))
                $result = dbquery("insert into ".$db_prefix."wst_results(league_id, matchday_id, match_id, team1, team2) values($lid, $md, $m_id[$i], $tipp1[$i], $tipp2[$i])");
        if (isset($data['team1']))
            if (isnum($tipp1[$i]) && isnum($tipp2[$i]))
                $result = dbquery("update ".$db_prefix."wst_results set team1=$tipp1[$i], team2=$tipp2[$i] where
                league_id=$lid and matchday_id=$md and match_id=$m_id[$i]");
                       
        $result = dbquery("select * from ".$db_prefix."wst_leagues where league_id=$lid");
        $data = dbarray($result);
               
        $conf = dbarray(dbquery("select * from ".$db_prefix."wst_config where league_id=$lid"));
               
        $vicp = $conf['config_vic'];
        $tiep = $conf['config_tie'];
               
        if ($data['tbl_enabled'] == 1) {
            $result = dbquery("select * from ".$db_prefix."wst_teampoints where league_id=$lid and matchday_id=$md and match_id=$m_id[$i] and team_id=$tid[$i]");
            $data = dbarray($result);
            if (!isset($data['points'])) {
                if (isnum($tipp1[$i]) && isnum($tipp2[$i])) {
                    if ($tipp1[$i]> $tipp2[$i]) {
                        $result = dbquery("insert into ".$db_prefix."wst_teampoints(league_id, matchday_id, match_id, team_id, team_win, team_tie, team_lose, score_for, score_against, points)
                        values($lid, $md, $m_id[$i], $tid[$i], 1, 0, 0, $tipp1[$i], $tipp2[$i], $vicp)");
                        $result = dbquery("insert into ".$db_prefix."wst_teampoints(league_id, matchday_id, match_id, team_id, team_win, team_tie, team_lose, score_for, score_against, points)
                        values($lid, $md, $m_id[$i], $tid2[$i], 0, 0, 1, $tipp2[$i], $tipp1[$i], 0)");
                    }
                    if ($tipp1[$i]==$tipp2[$i]) {
                        $result = dbquery("insert into ".$db_prefix."wst_teampoints(league_id, matchday_id, match_id, team_id, team_win, team_tie, team_lose, score_for, score_against, points)
                        values($lid, $md, $m_id[$i], $tid[$i], 0, 1, 0, $tipp1[$i], $tipp2[$i], $tiep)");
                        $result = dbquery("insert into ".$db_prefix."wst_teampoints(league_id, matchday_id, match_id, team_id, team_win, team_tie, team_lose, score_for, score_against, points)
                        values($lid, $md, $m_id[$i], $tid2[$i], 0, 1, 0, $tipp2[$i], $tipp1[$i], $tiep)");
                    }
                    if ($tipp1[$i]< $tipp2[$i]) {
                        $result = dbquery("insert into ".$db_prefix."wst_teampoints(league_id, matchday_id, match_id, team_id, team_win, team_tie, team_lose, score_for, score_against, points)
                        values($lid, $md, $m_id[$i], $tid[$i], 0, 0, 1, $tipp1[$i], $tipp2[$i], 0)");
                        $result = dbquery("insert into ".$db_prefix."wst_teampoints(league_id, matchday_id, match_id, team_id, team_win, team_tie, team_lose, score_for, score_against, points)
                        values($lid, $md, $m_id[$i], $tid2[$i], 1, 0, 0, $tipp2[$i], $tipp1[$i], $vicp)");
                    }
                }
            } else {
                    if (isnum($tipp1[$i]) && isnum($tipp2[$i]))    {
                        if ($tipp1[$i]> $tipp2[$i]) {
                            $result = dbquery("update ".$db_prefix."wst_teampoints set team_win=1, team_tie=0, team_lose=0, score_for=$tipp1[$i], score_against=$tipp2[$i], points=$vicp
                            where league_id=$lid and matchday_id=$md and match_id=$m_id[$i] and team_id=$tid[$i]");
                               
                            $result = dbquery("update ".$db_prefix."wst_teampoints set team_win=0, team_tie=0, team_lose=1, score_for=$tipp2[$i], score_against=$tipp1[$i], points=0
                            where league_id=$lid and matchday_id=$md and match_id=$m_id[$i] and team_id=$tid2[$i]");                           
                        }   
                        if ($tipp1[$i]==$tipp2[$i]) {
                            $result = dbquery("update ".$db_prefix."wst_teampoints set team_win=0, team_tie=1, team_lose=0, score_for=$tipp1[$i], score_against=$tipp2[$i], points=$tiep
                            where league_id=$lid and matchday_id=$md and match_id=$m_id[$i] and team_id=$tid[$i]");
                               
                            $result = dbquery("update ".$db_prefix."wst_teampoints set team_win=0, team_tie=1, team_lose=0, score_for=$tipp2[$i], score_against=$tipp1[$i], points=$tiep
                            where league_id=$lid and matchday_id=$md and match_id=$m_id[$i] and team_id=$tid2[$i]");
                        }
                        if ($tipp1[$i]< $tipp2[$i]) {
                            $result = dbquery("update ".$db_prefix."wst_teampoints set team_win=0, team_tie=0, team_lose=1, score_for=$tipp1[$i], score_against=$tipp2[$i], points=0
                            where league_id=$lid and matchday_id=$md and match_id=$m_id[$i] and team_id=$tid[$i]");
                               
                            $result = dbquery("update ".$db_prefix."wst_teampoints set team_win=1, team_tie=0, team_lose=0, score_for=$tipp2[$i], score_against=$tipp1[$i], points=$vicp
                            where league_id=$lid and matchday_id=$md and match_id=$m_id[$i] and team_id=$tid2[$i]");
                        }
                    }   
            }   
        }
    }

    if ($data1['istoto'] == 1) {                           
        for ($i=0; $i<sizeof($m_id); $i++) {           
            $tt = $toto[$i];
            $result = dbquery("select * from ".$db_prefix."wst_results where league_id=$lid and matchday_id=$md and match_id=$m_id[$i]");
            $data = dbarray($result);
               
            if (!isset($data['toto']))
                $result = dbquery("insert into ".$db_prefix."wst_results(league_id, matchday_id, match_id, toto) values($lid, $md, $m_id[$i], $tt)");
                       
            if (isset($data['toto']))
                $result = dbquery("update ".$db_prefix."wst_results set toto=$tt where
                league_id=$lid and matchday_id=$md and match_id=$m_id[$i]");                   
        }
    }
    $st_wahl = true;
    $st_list = (isset($_POST['match']) && isNum($_POST['match'])) ? $_POST['match'] : 0;
}   
       
// TOTO !!!!!!!!!!!!!
$result_toto = dbquery("select * from ".$db_prefix."wst_leagues where league_id=$lid");
$toto = dbarray($result_toto);   
   
$matchdid = (isset($_GET['md']) && isNum($_GET['md'])) ? $_GET['md'] : 1;
   
       
if ((isset($_POST['st_wahl']) && $_POST['st_wahl'] == TRUE) || isset($matchdid) || isset($md)) {
    $md = (isset($_GET['md']) && isNum($_GET['md'])) ? $_GET['md'] : 1;
    if ((isset($_POST['st_wahl']) && $_POST['st_wahl'] == TRUE))
        $md = (isset($_POST['st_list']) && isNum($_POST['st_list'])) ? $_POST['st_list'] : 0;
    else {
        if (isset($md) && !isset($st_wahl))
            $md=$md;   
        if (isset($matchdid) && !isset($_POST['st_wahl']))
            $md=$matchdid;
               
        if (isset($_GET['md']) && !isset($st_wahl))
            //$md= isNum($_GET['md']) ? $_GET['md'] : 1;   
            $md= $matchdid;   
    }
    include "../inc/md_select.php";   
           
    opentable($locale['wst116']." ".$md.". ".$locale['wst116']);
        echo '<center><form method="post"><table width="100%" align="center" cellpadding="4" cellspacing="1" border="0" class="tbl-border"><tr class="tbl1">';
        echo '<tr class="tbl2"><td align="center">'.$locale['wst130'].'</td><td align="center">'.$locale['wst131'].'</td>
        <td align="center"></td><td align="center">'.$locale['wst132'].'</td><td align="center"></td>
        <td align="center">'.$locale['wst133'].'</td><td align="center" colspan="2">'.$locale['wst134'].'</td>
        <td align="center">'.$locale['wst152'].'</td><td align="center" colspan="2">'.$locale['wst153'].'</td>
        <td align="center">'.$locale['wst209'].'</td></tr>';
        $result = dbquery("select * from ".$db_prefix."wst_matchdays where league_id=$lid and matchday_id=$md order by matchday_datestamp");
        $zeige_calc = 0;  //TOXIC
        while ($data = dbarray($result)) {
            $tid = $data['team1'];        
            echo '<input type="hidden" name="match" value="'.$data['matchday_id'].'">';
            $result2 = dbquery("select * from ".$db_prefix."wst_teams where team_id=$tid");
            $data2 = dbarray($result2);
            $team1_details = dbarray(dbquery("select * from ".$db_prefix."wst_teaminfo where team_id=$tid"));   

            echo '<input type="hidden" name="tid[]" value="'.$tid.'">';
            $tid2 = $data['team2'];
            $result3 = dbquery("select * from ".$db_prefix."wst_teams where team_id=$tid2");
            $data3 = dbarray($result3);
            $team2_details = dbarray(dbquery("select * from ".$db_prefix."wst_teaminfo where team_id=$tid2"));   
            echo '<input type="hidden" name="tid2[]" value="'.$tid2.'">';
               
            $datum = getdate($data['matchday_datestamp']);
            echo '<tr class="tbl1">';
            echo '<td align="center"><input type="hidden" name="m_id[]" value="'.$data['match_id'].'">
            '.date("d.m.Y", $data['matchday_datestamp']).'</td>';       
            echo '<td align="center">'.date("H:i", $data['matchday_datestamp']).'</td>';
            echo '<td align="center">';
            if ($data2['team_logo'] != "") {
                if (file_exists("../img/teams/".$data2['team_logo'])) {
                    if (isset($team1_details['team_id']))
                        echo '<a href="../league.php?act=sh_td&lid='.$lid.'&tid='.$tid.'" title="'.$data2['team_name'].'"><img src="../img/teams/'.$data2['team_logo'].'" height="21" border="0"></a></td>';
                    else {
                        if ($data2['team_website'] != "")
                            echo '<a href="'.$data2['team_website'].'" title="'.$data2['team_name'].'" target="_blank"><img src="../img/teams/'.$data2['team_logo'].'" border="0" height="21"></a></td>';
                        else echo '<img src="../img/teams/'.$data2['team_logo'].'" height="21"></td>';
                    }
                } else echo '<img src="../img/nologo.gif" height="21"></td>';
            }    else echo '<img src="../img/nologo.gif" height="21"></td>';
               
            if (isset($team1_details['team_id']))
                echo '<td align="center"><a href="../league.php?act=sh_td&lid='.$lid.'&tid='.$tid.'" title="'.$data2['team_name'].'">'.$data2['team_name'].'</a></td>';
            else {
                if ($data2['team_website'] != "")
                    echo '<td align="center"><a href="'.$data2['team_website'].'" title="'.$data2['team_name'].'" target="_blank">'.$data2['team_name'].'</a></td>';
                else echo '<td align="center">'.$data2['team_name'].'</td>';   
            }
                   
            echo '<td align="center">';
           
            if ($data3['team_logo'] != "") {
                if (file_exists("../img/teams/".$data3['team_logo'])) {
                    if (isset($team2_details['team_id']))
                        echo '<a href="../league.php?act=sh_td&lid='.$lid.'&tid='.$tid2.'" title="'.$data3['team_name'].'"><img src="../img/teams/'.$data3['team_logo'].'" height="21" border="0"></a></td>';
                    else {
                        if ($data3['team_website'] != "")
                            echo '<a href="'.$data3['team_website'].'" title="'.$data3['team_name'].'" target="_blank"><img src="../img/teams/'.$data3['team_logo'].'" border="0" height="21"></a></td>';
                        else echo '<img src="../img/teams/'.$data3['team_logo'].'" height="21"></td>';
                    }
                } else echo '<img src="../img/nologo.gif" height="21"></td>';
            } else echo '<img src="../img/nologo.gif" height="21"></td>';
                   
            if (isset($team2_details['team_id']))
                echo '<td align="center"><a href="../league.php?act=sh_td&lid='.$lid.'&tid='.$tid2.'" title="'.$data3['team_name'].'">'.$data3['team_name'].'</a></td>';
            else {
                if ($data3['team_website'] != "")
                    echo '<td align="center"><a href="'.$data3['team_website'].'" title="'.$data3['team_name'].'" target="_blank">'.$data3['team_name'].'</a></td>';   
                else echo '<td align="center">'.$data3['team_name'].'</td>';   
            }
                                               
            $mmid = $data['match_id'];
            $result4 = dbquery("select * from ".$db_prefix."wst_results where league_id=$lid and matchday_id=$md and match_id=$mmid");
            $data4 = dbarray($result4);       

            if ($toto['istoto'] == 1) {           
                echo '<td align="center" colspan="2">
                <select name="toto[]">';   
              if ($data4['toto'] == 1)
                    echo '<option value=1 selected>'.$locale['wst137'].'</option>';
                else echo '<option value=1>'.$locale['wst137'].'</option>';
                if ($data4['toto'] == 0)
                    echo '<option value=0 selected>'.$locale['wst138'].'</option>';
                else echo '<option value=0>'.$locale['wst138'].'</option>';
                if ($data4['toto'] == 2)
                    echo '<option value=2 selected>'.$locale['wst139'].'</option>';
                else echo '<option value=2>'.$locale['wst139'].'</option>
                </select></td>';       
            }
           
            if ($toto['istoto'] == 0)    {           
                if (isset($data4['team1']))           
                    echo '<td align="center">'.$data4['team1'].'<input style="display:none" type="text" size="3" maxlength="3" name="tipp1[]" value="'.$data4['team1'].'" class="textbox"></td>';
                else echo '<td align="center"><input type="text" size="3" maxlength="3" name="tipp1[]" class="textbox"></td>';
                if (isset($data4['team2']))
                    echo '<td align="center">'.$data4['team2'].'<input style="display:none" type="text" size="3" maxlength="3" name="tipp2[]" value="'.$data4['team2'].'" class="textbox"></td>';
                else echo '<td align="center"><input type="text" size="3" maxlength="3" name="tipp2[]" class="textbox"></td>';
            }
               
            if (isset($data4['team1'])) {
                if ($data4['calc']==1) {
                    echo '<td align="center"><img src="../symbols/yes.gif"></td>';
                    echo '<td></td>';
                }    else {
                        echo '<td align="center"><img src="../symbols/no.gif"></td>';
                        echo '<td align="center"><a href="league_admin.php?act=calc_points&lid='.$lid.'&md='.$md.'&mid='.$mmid.'" title="'.$locale['wst271'].'"><img src="../symbols/calc.gif" border="0"></a></td>';
                        $zeige_calc = 1; //TOXIC
                }
            } else echo '<td></td><td></td>';
            echo '<td align="center"><a href="league_admin.php?act=del_result&lid='.$lid.'&md='.$md.'&mid='.$mmid.'" title="'.$locale['wst272'].'"><img src="../symbols/delete.png" border="0"></a></td>';
            echo '<td><a href="league_admin.php?act=edt_details&lid='.$lid.'&md='.$md.'&mid='.$mmid.'" title="'.$locale['wst273'].'">'.$locale['wst210'].'</a></td>';
        }
           
        // V1.1 // TOXIC
        if ($zeige_calc) {
            echo '</tr>';
            echo '<tr class="tbl1"><td align="right" colspan="9">'.$locale['wst359'].'</td>';
            echo '<td align="center"><a href="league_admin.php?act=calc_allpoints&lid='.$lid.'&md='.$md.'" title="'.$locale['wst359'].'"><img src="../symbols/calc.gif" border="0"></a></td>';
            echo '<td align="right" colspan="3"></td>';
            // V1.1
        }   
        echo '</tr><tr class="tbl2"><td align="center" colspan="13">
                    <input type="submit" name="save" value="'.$locale['wst140'].'" class="button">
                    </td></tr></table></form></center>';
    closetable();
}
?>

Kunne du hjælpe?

jeg kender ikke noget til fusion, så jeg har ingen anelse om hvad der sker før det postede script køres, men hvis det virker på den ene og ikke på den anden, lyder det jo umiddelbart som nogle indstillinger på serveren, eller at den nye server kører en nyere version end den gamle, og der er ting i dit script som ikke virker med den nye version, men jeg synes ikke jeg kan se noget i koden, der skulle trigge det...

kan du se versionen på din gamle server kontra den nye?

Jeg tror ikke det skyldes det.

Problemet er, at spillet kan bruges på 2 forskellige måder, den ene virker, men når jeg bruger den anden(toto), så virker den ikke helt rigtigt..

Så derfor har det vel ikke noget med server versionen at gøre..

virker begge spil på den gamle server?

jaa, det derfor det er lidt underligt..

hvis de 2 scripts er præcis ens, kan jeg ikke se hvad der ellers skulle gøre en forskel udover server-konfig...

Så hvad det det jeg skal tjekke ifht server-konfik? database version, eller hvad?

jeg ville starte med en phpinfo fra begge servere og sammenligne dem...

hmm, men har det nogen indflydelse, når det ene spil virker, mens det andet kun virker halvt?

åbenbart...

når scriptene er 100% ens, kan det jo ikke være det.

eller det kan det jo, det kommer an på hvordan man ser på det - hvis de 2 servere har forskellige versionsnumre, er der jo nok noget der ikke passer sammen, siden det ikke virker 100%

gamle domæne Phpmyadmin: Serverversion: 5.1.52
Nye domæne phpmyadmin: Serverversion: 5.1.54

Men phpmyadmin burde ikke have nogen indflydelse sagde de på mit nye domæne.

nye domæne php server: Alle vores "PHP servere" benytter en specialopsat og optimeret version af Linux.

gamle domæne php: Apache version 2.2.19

Jeg får følgende fejlmelding nu:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where league_id=22 and matchday_id=1 and match_id=0' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where league_id=22 and matchday_id=1 and match_id=1' at line 1

Når jeg sidder og kigger på koden, bliver der brugt en masse variabler inden de er sat, er det global variabler, for i så fald, kunne det vel godt være den setting der er slået fra på den nye server?

For at være ærlig, så er jeg ikke den skarpeste til php..

Kan du forklarer hvad du præcist mener ?

kør en fil med følgende kode:



på begge sider og kig dem igennem for forskelle...

Jeg kan se, at det gamle domæne kører PHP Version 5.2.17
mens det nye domæne kører på PHP Version 5.3.6

Gamle domæne system: System    Linux phantom.websitewelcome.com 2.6.38.7 #5 SMP Wed Jun 8 01:26:17 CDT 2011 i686

Nye domæne system:
System    Linux linux10.unoeuro.com 2.6.18-338.12.1.el5.lve0.8.34 #1 SMP Tue Jun 7 16:46:50 EEST 2011 x86_64

hmm, jeg tror ikke det er php-versionen der gør en forskel...

jeg kan ikke lige komme på hvad der skulle drille, desværre

er der forskel på om global variables er enabled?

det kan der meget vel være - hvis det er enabled på den gamle og disabled på den nye, kan det godt give de fejl...

@zidane, kan vi få lov til at tage et kig på php konfigfilerne?

Lukker denne tråd. Brugt dn forkerte php version.