In message <990186.8983.qm@xxxxxxxxxxxxxxxxxxxxxxxxxxx>, Reji Jayan <for_rejijayan@xxxxxxxxxxx> writes >Hello, > >Pete asked in a mail whether i couldn't access it with browser or not, > >what i found is no .. but i would like to clarify with the client whether is >there any way which i dont know and he will come online only after couple of >hours > >but how to make this out ..................... You can either do it manually - download the files via FTP, and upload the data to your site, or you can do it automatically - however, because your client has not done it correctly, and provided the data on an XML page, and has not made the page accessible via HTTP, then you have to write a FTP routine, http://us3.php.net/manual/en/book.ftp.php to get the data, then upload it. You can either upload it with LOAD DATA INFILE this assumes that the data is correct, and no errors (as there were in previous emails) http://dev.mysql.com/doc/refman/5.1/en/load-data.html It also means that you have to delete the data that was in your database already, as you can only INSERT, UPDATEs are possible but complicated Alternatively, you may wish to read each line with fgets(), get the fields out with explode(), then correct and adjust any fields, and INSERT each record separately. I do this from and to various companies, and we always use XML. -- Pete Clark Hot Costa - Local Spain http://www.hotcosta.com
