Emailing from MYSQL table...

[mscreashuns]

This may seem a bit odd, here's my situation.

I have a mailing list set up for my new machinima series so people can be updated on news and all that.

Anyway, I have a MYSQL table set up with these columns:

User Number
Name
Email

Is there an easy way to email all the addresses stored in the table?

Could I possibly use PHP and use the mail() function, and where you would put the addresses, have it select from the table?

Let me know if that would work or what I need to do! Thanks!

[leatherback]

Hi,

(Have a look at the threat by bakz in newbies)

There I gave this snippetm, which assumed an email_id to be posted with a form:

$id = $_POST['id']; // Do some maliceous code trapping, if you have a script

$getid_query = "select * from contact where id=$id"; 

$result = mysql_query($getid_query) or die(mysql_error());

while($row = mysql_fetch_array($result))
  {
  $receiveremail = $row['email'];
  }

You could change this quickly to:

$getid_query = "select * from contact"; 

$result = mysql_query($getid_query) or die(mysql_error());

while($row = mysql_fetch_array($result))
  {
  mail($row['email'], $subject, $message, $sender) ;
  }

[mscreashuns]

Alright.

Would it work if I don't have a column called "id"?