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 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.