I've got a little question about my script, I'm trying to enter a lot of data in my MySQL database but I've got the next problem
I can't enter the data with php because there is a space in one of my column names
here is the code
$qw1 = "voornaam, achternaam, straat, postcode, geboortejaar, telefoonnummer, email, ORDER DATE";
$qw2 = "'$vnaam', '$anaam','$straat', $code, $geboorte, $tel, '$email', '$dateandhour'";
mysql_query("INSERT INTO bestellingen ($qw1) VALUES ($qw2)");
I hope someone could help me, thanks in forward !
解决方案
why dont you use the sql error ? so you can see what the msitake is .
try this
mysql_query("INSERT INTO bestellingen ($qw1) VALUES ($qw2)") or die(mysql_error());
use backticks around this also
`ORDER DATE`
Note: this ` is not same as this '
try this
$qw2 = $vnaam .','.$anaam .','.$straat.','. $code.','. $geboorte.','. $tel.', '.$email.', '.$dateandhour ;