I get this error, Query was empty?

bike5

This is what I have-

$cash = $colum[user_money] - 100;
echo "$cash $TableName";
$query = "UPDATE $TableName SET user_money = '$cash' WHERE user_session = '$user_islogged'";
echo "$colum[user_session] $user_islogged";
$Result = mysql_db_query($DBName, $query, $Link);
mysql_query($Result) or die(mysql_error());

Everything is showing up on the echo's and all the names are correct. Yet I get this error.

Warning: 1 is not a valid MySQL-Link resource in /home/virtual/site135/fst/var/www/html/dbl/rpg/battle.php on line 120
Query was empty

Any ideas?

Anon

you are passing a 1 to the mysql_query because the query has been run, successfully.

instead of $Result = mysql_db_query()...

Remove that line, and change it to this:

$Result = mysql_query($query, $Link);

That should solve the problem. Basically, the 1 is the return from the query that result was running, and then you tried to run it again.

-Patrick