Hi everyone!

Unexpected situation. Is there a setting in MySQL that permits a record to be output to the requesting page even though one of the two value pairs is incorrect? And if so, can it be changed?
Here's the problem:

I have attached a querystring to a URL. It has two value pairs, Film_ID and FilmTitle. When passed to the browser, they successfully retrieve the record, but when I alter the value of Film_ID in the actual URL, to another value, i.e. 1 to 15, the form will display a different record, EVEN THOUGH I have not changed the value of FilmTitle.

What am I missing here? Shouldn't the form simply be empty if I fail to change both values?

Thanks for your comments.

What is your query?

Try executing the same query in query browser and you will have the same result as the webpage.

what is the query on the page

Distributor_Film_Information_Form.php

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.