Page 1 of 1

Simple email insert issue!

Posted: Fri Feb 19, 2010 11:39 am
by cap2cap10
hello again, php technorati. How do I insert 3000 email addresses into mysql table with only 1 ID field(auto increment) and email field using a insert query? :banghead:

Thanks again


Batoe

Re: Simple email insert issue!

Posted: Sat Feb 20, 2010 4:53 am
by netgoons
what is you data source? file as in csv/xls or to be entered manually through a UI?
If you just need to store the damn data then upload it directly to the database why bother with PHP?

Re: Simple email insert issue!

Posted: Sat Feb 20, 2010 8:07 am
by cap2cap10
Yea, I tried doing that through phpadmin but for some reason it only adds 2 addresses to the database. It is a CSV file. I am totally perplexed! :banghead:

It is a CSV (comma delimited file), So i tried to do manually using this code:

Code: Select all

mysql_query("INSERT INTO mail_list_3( mailID, email) VALUES
(' ', 'rcold@spa.net',..........) ") or die(mysql_error());
I am getting this error:
Column count doesn't match value count at row 1
I know I am close though!

Thanks in advance,


Batoe