Hi
I have changed my image database table and added a Foreign Key the looks at the users ID of the users table. I have also created a new Primary Key for my image table called CustID.
I also made a new system using the wizard to filler the results pages based on the session variable.
However, although the registration part of the system works fine, signing up and loging in.
The image part does not insert. I get the following error:
Cannot add or update a child row: a foreign key constraint fails (`login`.`imagetable`, CONSTRAINT `imagetable_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `users` (`UserID`) ON DELETE CASCADE ON UPDATE CASCADE)
I have attached my databases If you would be kind enough to take a Look, this may help you decide what the problem is?
Thanks