how do i

[spick]

hey i got a question



i am creating a vB3 battle system



im stuck on this problem i created a textfield with the name="winner"



and in my newreply.php i used the code

PHP Code:


// update battles

$winid = $DB_site->query_first("SELECT username FROM ".TABLE_PREFIX."user WHERE userid='$winner'");

 

if ($winid['username'] > 0) 

{

$DB_site->query("UPDATE ".TABLE_PREFIX."user SET wins=wins+1 WHERE username='$winid[username]'");

}

 

 

// end of battle update 


but it does nuthing and i tried more codes but dont seem to work can any body help me??

[Brad]

Change $winner to

PHP Code:

$_POST['winner'] 


[spick]

then ill get this error

PHP Code:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in c:\program files\easyphp1-7\www\upload\newreply.php on line 334 


ill make a screen with it what im trying to build

[Brad]

What is on line 334 of that file?

[spick]

PHP Code:

// update battles 

$winid = $DB_site->query_first("SELECT username FROM ".TABLE_PREFIX."user WHERE userid='$_POST['winner'] '"); 



if ($winid['username'] > 0) 

{ 

$DB_site->query("UPDATE ".TABLE_PREFIX."user SET wins=wins+1 WHERE username='$winid[username]'"); 

} 





// end of battle update 


this is on that line

[Mike343]

try chaning $_POST['winner'] to $_POST[winner]

[spick]

ok got the page back on now but it still doenst update

this is the template part i use for it maybe there is the error

PHP Code:

<!--START BATTLE SYSTEM UPDATER-->
                <if condition="$show['admincplink']">
                <fieldset class="fieldset">
                    <legend>Battle System Updater (ADMIN VIEW ONLY)</legend>
                    <div style="padding:$stylevar[formspacer]px">
                        <div>
Winner Id <br><form action="newreply.php"  name="name" method="update"><input type="textfield" name="winner" value="$winner"><br>vs <br>Loser Id<br><input type="textfield" name="losser" value="$losser"><input type=submit name=verzenden></form></div>
                </fieldset>
                </if>
                <!--END BATTLE SYSTEM UPDATER-->