Search found 7 matches

by afoote
Wed Aug 02, 2006 1:41 pm
Forum: PHP - Code
Topic: Importing CSV To MySQL
Replies: 10
Views: 509

Ya, the MySQL statement is totally message up.... it's not getting the fields names property from the CSV file only the "list_id" and as I figured it was not doing the other two ones "member_id" and "date" , instead its putting the "field names as values". INS...
by afoote
Wed Aug 02, 2006 1:03 pm
Forum: PHP - Code
Topic: Importing CSV To MySQL
Replies: 10
Views: 509

thanks, some progress..

Hey, Thanks That got ride of that error, so some progress --- but now there is a new error.. Column count doesn't match value count at row 1 I think I know what the problem is, however I just am not sure how to fix it, I could be wrong, but I think it has to do with those extra DB fields that are no...
by afoote
Wed Aug 02, 2006 12:04 pm
Forum: PHP - Code
Topic: Importing CSV To MySQL
Replies: 10
Views: 509

What Is Wong???

Hey All... I've got this code and I've played around with it forever now but nothing seams to work, I have no idea what is wrong or how to correct. It is suposed to take the imported CVS file and: 1. Read the first line to fine the "field names" in the CVS header file 2. Then make an array...
by afoote
Fri Jul 28, 2006 1:27 pm
Forum: PHP - Code
Topic: Importing CSV To MySQL
Replies: 10
Views: 509

Thanks...

Hey, Thanks for your reply, still a little lost but I will see what I can do what you gave me, like I said still new at this, but doing my best to learn...
by afoote
Thu Jul 27, 2006 6:19 pm
Forum: PHP - Code
Topic: Importing CSV To MySQL
Replies: 10
Views: 509

I know that... Actually just figured that out a little while ago, does a great job as well.

but this is for people visiting the site to use , its a php script that takes the form results (the users upload the CVS file via the form). I can't let my members use PhpMyAdmin...
by afoote
Thu Jul 27, 2006 6:11 pm
Forum: PHP - Code
Topic: Importing CSV To MySQL
Replies: 10
Views: 509

Oh & Ya....

The only other thing I can think of is, and I may be totally wrong here, let me know if I am, but I've got this script that will take the CSV file and echo out a Array, like below, just repeates over and over again - for each line in the CSV file.. Is a way I can take this array and place it into th...
by afoote
Thu Jul 27, 2006 6:00 pm
Forum: PHP - Code
Topic: Importing CSV To MySQL
Replies: 10
Views: 509

Importing CSV To MySQL

feyd | Please use , and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color] [b]Hey Al...