Select random rows & then email

[Horse]

Hi All,

I'm a bit of a newbie and I'm a little stumped by this so if anyone can help it would be very much appreciated!

 

First here's a bit of table structure info...

 

Table: USERS

id  email

1    user@domain.com

 

 

Table: QUOTES

id  Link                      Quote

1    www.domain.com    blah blah...

 

 

What I need to do is create a script that, when executed, will send an email to each of the users in the USERS table with 10 random quotes/links from the QUOTES table. Can any of you experts point me in the right direction?

 

Thanks!!!

[p2grace]

To grab ten random quotes use the following:

 

$query = "SELECT `id`,`link`,`quote` FROM `quotes` ORDER BY RAND() LIMIT 0,10";
$run = mysql_query($query);

[Stooney]

edit: p2grace had a better solution. 

[Horse]

Thanks for that. What about getting it to mail it to each of the users. I know how to write a mailer script but just not sure how I get it to send to each of the users? thanx

[p2grace]

Do you want it to send a separate email to each one, or include all of the users on the same email?

[Horse]

Send 10 different ones to each user so it will be separate emails. Thanks!

[p2grace]

Try this:

 

$query = "SELECT `email` FROM `users`";
$run = mysql_query($query);
while($arr = mysql_fetch_assoc($run)){
   extract($arr);
   $query2 = "SELECT `id`,`link`,`quote` FROM `quotes` ORDER BY RAND() LIMIT 0,10";
   $run2 = mysql_query($query2);
   $quotes = array();
   while($arr2 = mysql_fetch_assoc($run2)){
       extract($arr2);
       $quotes [] = array("link" => $link, "quote" => $quote);
   }
   // Email Script
   // To = $email;
   // Quotes = $quotes (this will be in the form of an array)
}

 

This should do the trick, just provide your email script where commented.