Hello all

Cannot create new table type – MySql query

The table name is Eyal-002

The query syntax is - SELECT * FROM `Eyal-002`

The error that I get is

wpDataTables backend error: No data fetched! Rendered query: SELECT * FROM Eyal-002 LIMIT 10 MySQL said: 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 '-002 LIMIT 10' at line 1 This usually happens when the MySQL query returns an empty result or is broken. Please check the results of the query in some DB manager (e.g. PHPMyAdmin)

I try to run the same query via PHP admin and manage to display the table content.

The table structure us very simple

id         age      name   home

1          age4    name4 home4

2          age5    name5 home5

My test website address is http://doctoroffice365.com

If you want I can send you admin username + password

i attach  a link to a screenshot

https://www.dropbox.com/s/94kr1pgruiz0d1q/q2.docx?dl=0

Best regards

Eyal 

yes , i will do si and update you