MySql insert using a php file

[vinny199]

Hi,

hope you can help,

I have to upload 3334 items in a table

table is called newsletter_subscribe

there are only 2 rows:

group_id for which i need to enter the value "1" 3334 times!

and

user_id wich is auto increment

so how can i get a php file to post 3334 items with $group_id = 1 for each item and empty for user_id?

that would be great help!

thanks,

Vinny

[czambran]

try this

mysql_connect('localhost','username','password');
mysql_select_db('DatabaseName');
for ($i=0;$i<3334;$i++)
{
$query="Insert INTO newsletter_subscribe (group_id ) values (1)";
mysql_query($query) or die(mysql_error());
}
echo " $i new records we added <br>";

[vinny199]

Thank you,

i did it slightly differently using your code.

worked great,

thanks again