[PHP]Help whit this code

[caja]

I create this code and I have a bit of dudes. Why not work:S!

          if ($act == 'changenam')
		  {
            $id = $_GET["charid"];
            $name = $_POST['name'];
            $oldname = $_POST['oldname'];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);

			$query = mysql_query("UPDATE characters SET charname = '$name' where charname = '$oldname");
			
			echo "<center><h3>Congratulations! Your name has been changed!</h3></center>";
			}	
			 
			 if ($act == 'changename')
			 {			 
	echo "<center><td colspan=4 align='center'><fieldset><legend>  <b>Change Name  </b></legend></td>";
	echo "<form action='changejob.php?a=changenam&charid=$id' method='post' >";
	echo "<td width ='107' align = 'right'><strong>New Name</strong></td></br>";
	echo "<td width ='151'><input size ='15' name='name' type='text'/></td></br></br>";
	echo "<td width ='107' align ='right'><strong>Old Name</strong></td></br>";
	echo "<td width ='151'><input size ='15' name='oldname' type='text'/></td></br>";
	echo "</br><td><input type='submit' value='Change my Name'/></td></br>";
	echo "</tr>";
	echo "</form>";
	echo "</fieldset></center>";
	}

 

[Meth0d]

You should explain what the problem is if you want us to help you..

 

[caja]

Edit: Now usseles for the update

 

[BBim]

Copy that from the change password part, its basically the same thing.

 

[caja]

Ok thnx BBim I go to try =)

 

[Pure]

Try:

<?
		 $act = $_POST['changeme'];
          if ($act == 'changename')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = '$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $name = $_POST['name'];
            $oldname = $_POST['oldname'];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
            $penya = $get['penya'];
            if ($penya >= 10000000)
            {
            mysql_query( "UPDATE characters SET charname = '$name' where charname = '$oldname");
            mysql_query("UPDATE characters SET penya = $penya -10000000 WHERE id = $id");
            
                  if (mysql_affected_rows() != 0)
               {
                  echo "<center><h3>Congratulations!Your name has change.</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Not enought money.</h3></center>";

        //Where put this for code for work    in this php
//Start here
        echo "<td colspan=4 align='center'>Change Name</td>";
        echo "<tr>";
        echo "<form action='index.php' method='post' name='changeme'>";
        echo "<td width ='107' align = 'right'><strong>New name</strong></td>";
        echo "<td width ='151'><input size = '15' name='name' type='text'/></td>";
        echo "<td width ='107' align = 'right'><strong>Old name</strong></td>";
        echo "<td width ='151'><input size ='15' name='oldname' type='text'/></td>";
        echo "<td><input type='submit' value='change'/></td>";
        echo "</tr>";
        echo "</form>";
//Finish here
        }
    }
} 
?>

See if that works, I've bolden the 'index.php', change it to what ever the page is called, then it should do it int he same page, I hope xD

 

[caja]

**UPDATED**
I need some help more:S!
Idk why not work, not change the name in database

 

[Pure]

Updated post above, check it out for more details.

 

[s-p-n]

Lol.. you left out an apostrophe here:

mysql_query( "UPDATE characters SET charname = '$name' where charname = '$oldname");

".. where charname = '$oldname'");

 

[caja]

Lol.. you left out an apostrophe here:

mysql_query( "UPDATE characters SET charname = '$name' where charname = '$oldname");

".. where charname = '$oldname'");

Thnx you jeje stupid error and don't find it:S
Thnx in advance

 

[s-p-n]

Thnx you jeje stupid error and don't find it:S
Thnx in advance

doing a mysql_error() would tell you that too