Thank you both for your help.
I replaced my custom error message with yours but as that part of the code was working fine it didn't do anything (as yet!

).
re: the chosing the database, I do that in my connection line.
I took this line of cod into phpmyadmin as suggested:
Code: Select all
insert into current_public select {'','year','month','number','title','animator','hardware','software','creationtime','rendertime','viewrecommend','animdescription','descriptionofcreation','mpg','jpg','rating','ratingafter','winner' } from current
and this is the result it gave me:
Code: Select all
Error
SQL-query :
INSERT INTO current_public
SELECT { '', 'year', 'month', 'number', 'title', 'animator', 'hardware', 'software', 'creationtime', 'rendertime', 'viewrecommend', 'animdescription', 'descriptionofcreation', 'mpg', 'jpg', 'rating', 'ratingafter', 'winner'}
FROM current
MySQL said:
#1064 - 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 ''', 'year', 'month', 'number', 'title', 'animator', 'hard
Any ideas? I can't quite figuire that one out
