Made some small changes, but basic question remains...
Hi Eric - I realised that what I should be doing for this add review page was to start off with a page with a dynamic drop-down (review_add.php) so that the user selects the location first, which then triggers the options for the practicenames, and once they've got the one they want to review from the child drop-down, they hit Submit and then arrive on the page where they can put in their review info (add_review.php).
So... I had to split the database down to add a new table (locations) and I've attached this along with the two pages that now form this select/add review part of the site as a zip file.
Please ignore the earlier version of the db sent across, this is now the one I'm working with.
I've got the drop downs working ok, and assume that I need somehow to pass the value of the practicename from the first page to the second somehow, but I'm now how to do this - I've added a text field on the second page with practicename bound to it from the recordset but I presume that something more complicated needs to happen with it to make the correct value be passed from the first page? If it's a javascript solution, I'd appreciate having this spelled out in words of one syllable as I'm even more of a newbie with js than I am with mysql/php.
I tried testing these two pages locally and although the first page redirects to the second, when this comes onscreen it still has this "Duplicate entry '0' for key 2" error message and nothing else displays.
It's 4.30pm Friday afternoon here in England, I'll check back later and hope you'll be able to help me move this on somewhat, I'm supposed to be showing this to the client on Monday... thanks in advance.