query

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO banners (link, banner, naam) VALUES("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]link[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]banner[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]")"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
?>

Geeft dit:

Quote:
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 , ) at line 1

Wie weet oplossing?

$_POST[naam] is leeg
en ik zou die dingen trouwens nog tussen s zetten

dus doordat iets leeg is gaat het fout?

ja,

INSERT INTO banners (link, banner, naam) VALUES(google.nl, google.nl/banner.gif, )

dat gaat niet werken

als alles ingevuld is krijg ike dit:
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 , lol) at line

je moet "dinges" doen ipv "dinges"

je moet naam nog tussen s zetten, dat zei sjoerd al

TNX