I currently have three tables.

board
Board_id
Title

thread
Thread_id
Title
Thread_Board_id (Foreign key linked to Board_id)

post
Post_id
Post_thread_id (Foreign key linked to Thread_id)
User
Message

Now i am new to mysql, only been using it a short while and am writing a website for my hockey club, so i figured the best way to learn would be to write everything for myself. i am currently doing k.

but have hit a problem when trying to update these tables.

I am trying to update them one after the other in the same php script.
(can post up here if you like)

I keep getting a cannot update foreign key constraint error.

I was wondering if anyone had any tips for this or a good place to go and have a look i dont seem to be able to find any sites that deal with this issue, or with how to use foreign keys properly in mysql and php.

thanks in advance for any help.