Why do incorrect value pairs still reflect a record?

[briandouglas]

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.

[dickersonka]

What is your query?

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

[briandouglas]

Thanks for responding. Here is the query:

<a href="http://www.mysite.com/CommandControl/Farsi1024/Distributor_Film_Information_Form.php?Film_ID=<?php echo $row_rsInitial_Email_to_Dist['Film_ID']; ?>&FilmTitle=<?php echo $row_rsInitial_Email_to_Dist['FilmTitle']; ?>">Yes, I'm curious</a>

[dickersonka]

what is the query on the page

Distributor_Film_Information_Form.php