PHP SQL MYSQL database name have bash (-) use group_concat can't print correct data

Asked Oct 05 '20 at 07:36

Active Oct 05 '20 at 08:10

Viewed 13 times

database

ID name-04 data-05 
1  The    CAT
2  Ring   Some
3  The    Dog

I am use GROUP_CONCAT(name-04 order by ID SEPARATOR ',') Output are not correct will display null. If use GROUP_CONCAT('name-04' order by ID SEPARATOR ',') will display name-04 name-04 How to fix.... My database have to need bash (-) ....

enter image description here

edited Oct 05 '20 at 08:10

asked Oct 05 '20 at 07:36

jason

You need to use backticks when enclosing field names in MySQL. – Nigel Ren Oct 05 '20 at 07:47
PHP can't use " name-A" – jason Oct 05 '20 at 07:50
Should be something like `GROUP_CONCAT(\`name-01\` order by ID SEPARATOR ',')` – Nigel Ren Oct 05 '20 at 07:53
I am use 'name-01' will display name-01 name-01 not my correct data.... – jason Oct 05 '20 at 07:58
Is there any PHP code you want to share? You haven't provided any parts where any output displays "null" – Nico Haase Oct 05 '20 at 09:38

PHP SQL MYSQL database name have bash (-) use group_concat can't print correct data

0 Answers0