please help...

[Anon]

I have this list with emails from a old maillist we have used, but now I have made a new maillist in php... but in the old list, the addresses is stored like this:
[e-mail]
[e-mail]
[e-mail]

so I wondered how I can insert all this addresses into my mySQL db.. could anyone help me..??

[techek]

I expect you know something about MySQL! So this is just the important part :

<?php
$emailfile = '~/passwords.list';
$data = file($emailfile);
// connect to DB here
while(list($index, $value) = each($data)) {
$sql = "INSERT INTO emails SET email='$value'";
// fire sql here
}
// close connection to DB here
?>

Hint : The WHILE-loop is just one way of traversing the data-array.

[Anon]

thanks alot, just what I needed 🙂