MySql_Query Error:

[Dethman]

hey I am getting this error:

Deposit SQL ERROR: 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 `userid` ='1'' at line 1

 

from this line:

<?php
$query_1="INSERT INTO `user_users` SET `credits` = `credits` -'{$amt}', `vault` = `vault` +'{$tax_amt}' WHERE `userid` ='{$id}'";
$query_mysql=mysql_query($query_1) or die("Deposit SQL ERROR: ".mysql_error());
?>

[unkwntech]

I dont see any error but try this:

<?php
$query_1="INSERT INTO `user_users` SET `credits` = `credits` -'" . $amt . "', `vault` = `vault` +'" . $tax_amt . "' WHERE `userid` = '" . $id . "'";
  echo $query_1;
?>

and dubble check that the query looks good.

[MasterACE14]

WHERE clause and INSERT INTO don't go together.

 

either UPDATE with WHERE, or INSERT INTO on its own.

 

ACE