After successfully connecting to the database in Dreamweaver CS4, the binding operation was immediately performed on the database. However, an inexplicable problem occurred during the test. When clicking on the binding test, a "FROM clause syntax error" prompt always appeared, as shown in Figure 1.
|
Figure 1 Dreamweaver error message |
After thinking for a long time, I finally found that the table name of a table in the database I created used the word "user". In fact, user is a system variable, and it will cause errors when used to create tables or fields. Therefore, in the future, table names should be prefixed or added with words such as rs to avoid similar situations.