You have chosen to sponsor your bid up to a maximum amount of .
Fix existing PHP coding to download a large zip file via FTP to FTP, unzip this file and input the data into and existing MYSQL database.
You can either fix the existing PHP or write your own. This PHP coding used to work at one time but I cannot figure out why it is not working now.
I will use a CRON job to make this happen every 24 hours. This is the FTP address of the zip file:
Included in this work is a small job fixing a PHP file to be able to query and select 2 fields from the same column.
This is the Code I am using now that doesn't work:
$query = "SELECT * FROM vesciALLmls WHERE STATUS_CODE = 'A' && SALE_PRICE != '' && TLN_FIRM_ID = '1040654' && PROPERTY_TYPE_CODE = 'M' && PROPERTY_TYPE_CODE = 'V' && PHOTO_IND='X' ORDER BY RAND() LIMIT 999";
Will entertain any REASONABLE bid!