How to run Insert query in php script which table name is a number

Question

I need to insert values to my table 9998 using a php script. First I tested a query for check database connection (query that commented) it work fine. Now I need to run the second query but it won't

//$sql1  = "UPDATE testTable SET rule = 'TEST' WHERE gid =".$edge["gid"];
  $sql1 = "INSERT INTO "9998"(forward_speed)VALUES (50);"

Note- I tested the insert query by executing in database using postgreSQL it executed correctly.

Ben Fortune · Accepted Answer · 2013-10-25 14:18:37Z

4

If you're using numbers as table names or if they start with a number, you need to escape them using backticks.

$sql1 = "INSERT INTO `9998` (forward_speed) VALUES (50);"

answered Oct 25, 2013 at 14:18

Ben Fortune

32.2k10 gold badges82 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Deepak Rai · Accepted Answer · 2013-10-25 14:17:07Z

1

  $sql1 = "INSERT INTO `9998` (forward_speed) VALUES (50);"

answered Oct 25, 2013 at 14:17

Deepak Rai

2,2113 gold badges24 silver badges39 bronze badges

Collectives™ on Stack Overflow

How to run Insert query in php script which table name is a number

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related