[ul][li]You only need quotes around column names if they contain ‘special’ characters, like a space.[/li]
[li]Strictly speaking, the ‘quotes’ around MySQL identifiers should be backquotes (character to the left of the 1 key on your keyboard) as shown above.[/li]
[li]I don’t think you need to include the ID field in the INSERT statement, because SQL will provide a value for it. (I may be wrong on this one, though!)[/li]
[li]mAirList automatically adds the quotes around logging variables in a VALUES clause. Don’t add any quotes yourself.[/li][/ul]
Assuming that datetime played is a SQL date/time column, it’s better and easier to use the SQL NOW() function to insert the current date/time. I should have thought of that earlier!
Cad i’m unable to try out what you have suggested as i am not at home right now…i shall try tomorrow.
Torben, i’m unsure what you mean, but i have attached an image of the table structure. Also note i have changed the name of the ‘length’ field, to ‘durtation’.
You should also rename “datetime played” to “datetimeplayed” or so. It’s not a good idea to have blank characters in table or column names because it will make writing queries somewhat difficult at times. I also suggest to use only lower-case characters, i.e., rename “ID” to “id”, for the same reason.