Mysql syntax error

Door Paul K op 26-11-2006 12:25

518 views

mysql_query("UPDATE bank SET contant = '$newcontant' SET bank = '$newbank' WHERE naam = '".$_SESSION['naam']."'")or die (mysql_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 'SET bank = '7000' WHERE naam = 'Fireworks'' at line 1

wat is er fout aan deze query?

Robert Deiman

26-11-2006 12:32

Je gebruikt 2 keer SET in je query:

<?php
mysql_query("
UPDATE
bank
SET
contant = '".$newcontant."',
bank = '".$newbank."'
WHERE
naam = '".$_SESSION['naam']."'");
?>

Reageren

Inloggen om te reageren