INSERT INTO not working on newest xampp

Question

$query = "INSERT INTO $stats_table_name (name, name_ID, anz_aufruf) VALUES ($plan_name, $plan_nr, $anz)"; echo "<br />".$query."<br />"; if (!mysql_query($query) && !$error) { die (mysql_error()); }

mysql-error tells me:

INSERT INTO 'p_stats' ('name', 'name_ID', 'anz_aufruf') VALUES ('Laptop 1', '1', '95')
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 ''p_stats' ('name', 'name_ID', 'anz_aufruf') VALUES ('Laptop 1', '1', '95')' at line 1

Where is the code wrong here?

score 3 · Answer 1 · edited May 23 '17 at 10:25

3

the error is the wrapping of single quotes around table name.

Table names as well as column names are identifiers. They should be wrap if a name is a reserved keyword with backtick (optional if not). Single quotes are for string literal.

MySQL - when to use single quotes, double quotes, and backticks?

edited May 23 '17 at 10:25

Community

1
1

answered Apr 12 '13 at 09:11

John Woo

258,903
69
498
492

score 0 · Accepted Answer · edited May 05 '14 at 06:12

0

Use this.

$query = "INSERT INTO $stats_table_name (name, name_ID, anz_aufruf) 
          VALUES ('".$plan_name."', '".$plan_nr."', '".$anz."')";

edited May 05 '14 at 06:12

Amal Murali

75,622
18
128
150

answered Apr 12 '13 at 09:17

Bharat Chodvadiya

1,644
4
20
31

score -1 · Answer 3 · edited Jun 05 '18 at 11:30

-1

$query = "INSERT INTO $stats_table_name (name, name_ID, anz_aufruf) 
          VALUES ('".$plan_name."', '".$plan_nr."', '".$anz."')";

edited Jun 05 '18 at 11:30

Yasin Patel

5,624
8
31
53

answered Jun 05 '18 at 10:51

Query

1

INSERT INTO not working on newest xampp

3 Answers3