I have an app in PHP that parses a CSV and inserts some of the records into MySQL. Then the user clinks on a link and then that record that is clicked on is exported to another table (one is a queue and the other is a status). The app displays file names that are transmitted. It works perfectly except for one instance: when customers send files with blank spaces in them. I am using fgetcsv to parse an FTP log and when a specific field contains a specific value, I export some of those values to a table. The FTP log file treats blank spaces as plus sugns, but these plus signs are subsequently treated as blank spaces by PHP and HTML. How can I parse the file name value before I do the insert statement and replace the plus signs with blank spaces? Or, if not that way, how can I get PHP and the HTML itself to treat the plus sign as a literal plus sign? I have two tables, a queue tableand a status table that are joined on filename. When filename doesn't match, I don't see the status for that file. The queue table (the parsing of the log) has the plus sign, and the subsequent entry into the status table has blank spaces. Help!
