Insert data in mysql colum with spaces with php

Question

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 !

use backticks - (two answers have appeared while I was writing this). I mean, it should really not be difficult to find this information googling a little bit, or, even better, reading the MySQL manual! — Walter Tross, Jul 12 '13 at 18:41
and it's impossible to use no spaces, because it are my clients who chose the name — Pieter-Jan Coenen, Jul 12 '13 at 19:16

score 0 · Answer 1 · edited Jul 12 '13 at 19:01

0

Use backticks (`) tilde symbol.

$qw1 = "voornaam, achternaam, straat, postcode, geboortejaar, telefoonnummer, email, `ORDER DATE`";

edited Jul 12 '13 at 19:01

Praveen

55,303
33
133
164

answered Jul 12 '13 at 18:39

perfectweb

59
1
7

thanks for the fast answer, but that didn't really worked my $qw1 now looks like this voornaam, achternaam, straat, postcode, geboortejaar, telefoonnummer, email, bestellingsdatum, 'Standaard', 'Standaard met drankbonnen' – Pieter-Jan Coenen Jul 12 '13 at 18:50
use backticks, not apostrophes. The backtick key is next to the "1" key. – perfectweb Jul 12 '13 at 18:54

score 0 · Answer 2 · edited Jul 12 '13 at 18:40

0

Use Backticks

 $qw1 = "`voornaam`, `achternaam`, `straat`, `postcode`, `geboortejaar`, `telefoonnummer`, `email`, `ORDER DATE`";

edited Jul 12 '13 at 18:40

Orangepill

24,500
3
42
63

answered Jul 12 '13 at 18:40

Kirtan

120
1
6

Thanks, for the fast answer, but that does not really work :/ – Pieter-Jan Coenen Jul 12 '13 at 18:47
Know the $qw1 looks like this 'voornaam', 'achternaam', 'straat', 'postcode', 'geboortejaar', 'telefoonnummer', 'email', 'bestellingsdatum', 'Standaard', 'Standaard met drankbonnen' – Pieter-Jan Coenen Jul 12 '13 at 18:48

echo_Me · Accepted Answer · 2013-07-12T19:26:32.790

0

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 ;

edited Jul 12 '13 at 19:26

answered Jul 12 '13 at 18:59

echo_Me

37,078
5
58
78

This is the syntax 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 'ORDER DATE') – Pieter-Jan Coenen Jul 12 '13 at 19:15
make order date as in my answer with backticks , just copy it and paste it in your code if you dont know what is backticks and single quote. backticks is not same as single quote – echo_Me Jul 12 '13 at 19:23
You really helped me out with it ! Thank you so much, i really didn't saw there is a diference between the two Thanks !!! – Pieter-Jan Coenen Jul 12 '13 at 19:40

score 0 · Answer 4 · answered Jul 17 '13 at 06:22

0

don't use spaces in column names, but use AS in your query. For example Select orderDate as 'ORDER DATE'

answered Jul 17 '13 at 06:22

John

1

Insert data in mysql colum with spaces with php

4 Answers4

Linked