Re: CSV Import Question
| From: | Chris Payne | Date: | Tue, 18 Nov 2003 05:07:46 +0000 |
| Subject: | Re: CSV Import Question | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31605@lists.php.net to get a copy of this message | ||
Hi there,
> 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?
Sorry, delim is from the form you use to select the CSV file, as you can
select the char as the seperator (I have set the default to a COMMA though).
Chris