Mysql version 5.0

Hello,
When I want to edit a page generated by data assist I obtain the following message :

"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 'Key, Identifiant, Password FROM adherents LIMIT 0, 20' at line 1"

What does it means ? Where is the error ?
The Mysql version used is the 5.0 (on 1 and 1 servers)

Thank you for your answer.

J.L. Gouget

key is a reserved word in mysql and should be avoided as a column name:
reserved-words.html

Thank you for this 1st answer ; the 1st problem is resolved, but now when I want to insert a mail adress like admin@laprovence.cc, I obtain the folowing message :
"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 '@laprovence.ccundefined,undefinedadminundefined)' at line 1"
Is the type of my basis which is a bad one : text

Thank you for your answer

Best regards.

Jean-Louis Gouget

try using the varchar data type instead of text.

It's what I have done without success. In attached file : the new structure. The link to try : adherents_Results.php

send a copy of your page in a zip archive please.

Here are the files : one for the copy of the page, the other for the structure of the table

open the server behaviors panel (Window -> Server Behaviors) and double click the insert record behavior.

make the data type selected for each of the columns in the insert record behavior is set to text.

The choice is only : text, integer, double, date, checkbox o,n, checkbox 0,1, checkbox 0,-1. What could I choose ? (see file in attachment)

choose text