PDA

View Full Version : need help with SQL syntax


arne
11-01-2005, 12:34 PM
Hi, i think there's a very stupid mistake i made in my sql syntax, can anybody help me :

@mysql_query("INSERT INTO leden WHERE gebruikersnaam = ".lekubb($_POST['gebruikersnaam'])." (status) VALUES (Global Admin)") or die(mysql_error());

Ik get this 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 gebruikersnaam = t (status) VALUES (Global Admin)' at lin

You can see the script online at http://www.webmasterhelp.be/systeem/testje.php
When you fill in something and press enter you'll see the error.
If you need more info or something you can mail me at arne_dejongh2@hotmail.com or post something here. PLease help !!!
Thanx
ADj

P.S. OEPS, i JUST SAW I HAD TO PUT THIS IN MYSQL FORUM, SORRY BUT I DON4T KNOW HOW TO REPLACE IT !

Rich Pedley
11-01-2005, 01:18 PM
as you are using WHERE in the query should you not be using UPDATE rather than INSERT INTO ?