You have an error in your SQL syntax; check the manual that corresponds to ...

[d22552000]

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 ' `Crystal`=`Crystal`+, `Dueterium`=`Dueterium`+ WHERE `uname` = 'd22552000'' at line 1

 

$sql = "SELECT * FROM `accounts`";
$result = mysql_query($sql);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
foreach($row as $user) {

	$sqla = "SELECT * FROM `galaxy` WHERE `Owner` = '" . $user . "'";
	$resulta = mysql_query($sqla);

	while($rowa = mysql_fetch_array($resulta, MYSQL_ASSOC))
	{
		$sqlb = "UPDATE `test`.`accounts` SET `Metal`=`Metal`+" . $row2['MetalIncome'] . ", `Crystal`=`Crystal`+" . $row2['CrystalIncome'] . ", `Dueterium`=`Dueterium`+" . $row2['DuerteriumIncome'] . " WHERE `uname` = '" . $user . "';";
		echo $row2['MetalIncome'];
		echo $row2['CrystalIncome'];
		echo $row2['DueteriumIncome'];
		mysql_query($sqlb) or die (mysql_error());
	}
}
}

 

What is wrong?

[pocobueno1388]

What is going on right here?

UPDATE `test`.`accounts`

 

Are you trying to update two tables at once? Or is the tables name "testaccounts" and for some reason you are trying to concate them together?

 

Look at the end of your query:

`uname` = '" . $user . "';";

 

You are closing it twice ";...take one out.

 

I'm surprised you aren't getting syntax errors for the above mistakes before you are getting an error from the executed query.

[d22552000]

test.accounts selects:

 

databse test:  table acounts.

 

I have to do this because my game uses database specific commands.

[Barand]

where is $row2 defined?