Hi ,

I am using Data Load Infile to load content of .txt file to my table ,my query is like this ,

'LOAD DATA INFILE "' . $filepath . '" ignore INTO TABLE mytablename FIELDS
TERMINATED BY "," ENCLOSED BY \'"\' LINES TERMINATED BY "\r" IGNORE 1 LINES'

This query working in my Local windows server ,but same in not working in Unix server.

Note: Although in Unix server if I run same query through PHPmyadmin , it gives results perfectly. But it is not working when I am using it in db_query().

Can some one suggest , what thing m I missing in above query.

Thanks

Bhuvenesh