Re: [PHP-DB] CSV Import Question

2003-11-18 Thread Chris Payne
Hi there, Yes, in the form itself there is an input field where you specify the character for import, as default it is set to , but you can change it to any. Chris On Tuesday 18 November 2003 13:07, Chris Payne wrote: any ideas? Here's the code: $row = 1; $handle = fopen

Re: [PHP-DB] CSV Import Question

2003-11-18 Thread Chris Payne
Hi there, Oh I know the , (Or $Delim) isn't the problem, I think your previous email may be the answer so i'll take a good look at that once i've eaten and if it works you're the best (Heck even if it doesn't you're all the best on this list ;-) Chris Try it with just , instead of $delim.

[PHP-DB] CSV Import Question

2003-11-17 Thread Chris Payne
Hi there everyone, 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,

Re: [PHP-DB] CSV Import Question

2003-11-17 Thread Jason Wong
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

Re: [PHP-DB] CSV Import Question

2003-11-17 Thread Chris Payne
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

Re: [PHP-DB] CSV Import Question

2003-11-17 Thread Jason Wong
On Tuesday 18 November 2003 13:07, Chris Payne wrote: 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