I have a database with two tables:
books, the fields are title_id, title, pages, publisher
author the fields are author_id, title_id, author
I can INSERT ok into either table as a speparate entry
but what I would like to do is enter the data into both fields from a form
instead of using phpmyadmin. It is the INSERT part I am stuck with.
Just to complicate it some of the books have more than one author :icon_rolleyes:
Any help or suggestions appreciated. Thanks