PHP and MySQL script randomly stopped working

PHP
1

Hi,

I just got a message from an old client. A property search page has randomly stopped working. It has been fine for a few months but suddenly there are no results to display, the MySQL query returns NULL everytime. The DB is fine and strangely the identical SALE page still works fine, taking the same info from the same table but just for sale properties.

Does anyone know why this could happen?

Thanks,
Rhys.

2

try PHP info to see if the version of PHP was changed

3

Thanks, I’ll try and find it (although their host is 1and1!).

I found the problem. All available properties suddenly had the field “let” changed to NULL. I will have to speak to my client and find out if any of his staff were using the admin cp before the problem. Maybe I left a coding error in there somewhere?

Thanks,
Rhys