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?
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!
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