Php script no longer works!

[Slime101]

We have an order lookup system, it simply queries a DB which is updated with a CSV file from time to time.

Sadly its stopped working and i know nothing about php or mysql. The scripts appear to be ok, they haven't changed the only thing that has altered is we moved servers a while back and its got a different version of php and mysql to the last ones, passwords, IP's etc were all updated and working.

I think its a DB problem as i can see the data in the tables using phpmyadmin but when i search for a postcode which i know is in there, it returns nothing!

Any ideas?

 

[Slime101]

Right - discovery made.

It seems the CSV file has "quotes" around each field, seperated by commas. For some reason the import script removes the " " round date fields, but not the text fields.

Removing those quotes before importing the data makes it work, however this needs to be automated, i'm sure it used to be!!!