Hi All
Please help guys i'm pulling my hair here. I need to import data from CSV file that is uploaded at runtime into a MySQL Database Table below is the syntax below it returns neither an error nor the warning.
$sql=" LOAD DATA LOCAL INFILE '".@mysql_escape_string($this->file_name)"'
INTO TABLE `DistributionGroup`
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(MobileNumber, FirstName) ";

Here is the continuation if needed
$res = @mysql_query($sql);

HI,
I'm not familiar with that, but a way of tackling it would be to try using phpmyadmin, going into the tab that lets you run queries, then you can paste in the appropriate query - replace the bits that you need to calculate, then run it and see what happens, that's how I usually find the faults in my stuff

hope that helps

Oh, I had another thought - file path - I just did some work that was a real pig because of file paths, some needed to be the full path on the server, like /home/ . . . and others needed to be from the site root, once I got those sorted out things went well.

Edited by - sitemaster on 22 Feb 2008 10:24:22

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
HI,
I'm not familiar with that, but a way of tackling it would be to try using phpmyadmin, going into the tab that lets you run queries, then you can paste in the appropriate query - replace the bits that you need to calculate, then run it and see what happens, that's how I usually find the faults in my stuff

hope that helps

Oh, I had another thought - file path - I just did some work that was a real pig because of file paths, some needed to be the full path on the server, like /home/ . . . and others needed to be from the site root, once I got those sorted out things went well.

Edited by - sitemaster on 22 Feb 2008 10:24:22
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I have tried this out with no success