Re: CSV Import Question

On Tuesday 18 November 2003 12:34, Chris Payne wrote: > I have a 2 Column CSV file, and i'm trying to import it into the DB via a > form, I have it importing fine with the first field (Called EMail) but I > cannot get it to import the second column correctly (Called name). I know > it's going to be something so obvious i'll pass out, but does anyone have > any ideas? Here's the code: > > $row = 1; > $handle = fopen ("$userfile","r"); > while ($data = fgetcsv ($handle, 250, "$delim")) { > $num = count ($data); > $row++; > for ($c=0; $c < $num; $c++) { > > mysql_query ("INSERT INTO emaillist (EMail,name) > VALUES ('$data[$c]','$data[$c]') > > When I import, it puts all data in the EMail field, even the name field. What's $delim? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* Business will be either better or worse. -- Calvin Coolidge */