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
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
