Hi there,
wondered if anyone out there had ideas about the following:-
I am using PHP and mySQL and have no knowledge of Javascript!
I need to create a record for a book in a books table. This book record has 5 possible authors fields:- auth1, auth2 etc. These are id's for my authors table. This table could grow to 200 or so authors. I need a method of selecting these five authors. I was hoping to select these from the insert book page having dynamic list options displaying options from the foreign authors table. These list/menus would obviously be too large.
Could anyone suggest another way I could select auth1, auth2. auth3 etc from within the insertbook page? Or would it be better to do it another way, by selecting all 5 authors first, maybe on one page and then passing the authid's as variables to the bookinsert page?
I am trying to find a solution without Javascript as I don't have the first clue about it!!
Thanks for any input,
Nick
