Date: 04/03/06 (MySQL Communtiy)    Keywords: php, mysql, html, sql

One of my projects has recently started listing results multiple times. The persons in charge of the servers say they have not updated the MySQL server or made any changes. In some cases I can accommodate for this by adding DISTINCT to the query. But on other pages, this is not helping.

From an email I just sent to my super':
"There is something up with our SQL server. I just looked at the View Profile page which I know I haven't touched in months and its also showing the profile page twice. In the PHP and HTML, the content is only there once and is called only for the results of the query. For some reason the query is suddenly calling two results of one row."

I am clueless about it. For over a year these things were working fine and only sending one result. Suddenly its sending two or more results for the same row.

If you guys have any idea why the server behavior and query results would change, or an hints at MySQL idiosyncracies, let me know. Thanks.

MySQL 4.1.11-Debian_4sarge2-log. PHP call used in the View Profile: $Result = mysql_db_query($host, $user, $password);

Source: http://community.livejournal.com/mysql/91645.html