MySql fetch error

[naveenmedia]

Hi all. I have a simple form pulling emails from a database which is using the PHP mail feature to send e-mails out to a mailing list.

The e-mails are in the table "members" and the field is called "email". So, I have the following PHP script:

<?php
$subject = $POST['subject'];
$message = $POST['message'];

$x = 1;
$hold = 50; //quantity of emails sent before 3 sec delay
$emails = mysql_query("SELECT email FROM members");

while ($sendemail = mysql_fetch_array($emails)) {
$email = $sendemail["email"];
mail($email, $subject, $message, "From: Mark <[e-mail]>");

$x++;
	if($x == hold) { //when $x is equal to $hold, a 3 sec delay will occur to avoid timeout
		sleep(3);
		$x = 0;
	}

} //end of while loop

?>

But I keep getting this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line 11, line 11 being this line:

while ($sendemail = mysql_fetch_array($emails)) {

Any reason why this argument is invalid? Help, I'm almost there!

[Jona]

[font=trebuchet ms]Hi,

Please try the following.[/font]

 $emails = mysql_query("SELECT * FROM `members`");

while ($sendemail = mysql_fetch_assoc($emails)) {
$email = $sendemail["email"];

[Jona]

[font=trebuchet ms]I just tested it, and your problem may be that you named your row differently. (E.g., "email" instead of "emails.") Make sure your mysql_query is a valid one. By using selecting * (all), you are getting everything. That would probably take more processing time than if you only selected the email row, so I wouldn't recommend using the code I just posted.[/font]

[naveenmedia]

No, still doesn't work.

I tried various changes.

I also changed "$emails" to "$allemails", just to alleviate the confusion with "$emails". Still nothing.

I changed mysql_fetch_array() to mysql_fetch_assoc() and it still keeps telling me that the supplied argument is not a valid MySQL result.

[Jona]

[font=trebuchet ms]Did you double-check to make sure your row was named "email" and the table was named "members"? It might be a good idea to just echo out the results to make sure the only reason you're not getting mail is because of a database problem, and not a mail server one.[/font]

[naveenmedia]

Yeah, I checked. Still gives me the same error. I'm trying different things...still stumped.

[Jona]

[font=trebuchet ms]As far as I can tell, it must be a configuration error. Here is the script I used, which works fine for me.[/font]

<?php

$db = mysql_connect("localhost", "user", "pass");
 mysql_select_db("tbl1");

$subject = $_POST['subject'];
$message = $_POST['message'];

$x = 1;
$hold = 50; //quantity of emails sent before 3 sec delay
$emails = mysql_query("SELECT `emails` FROM `members`");

while ($sendemail = mysql_fetch_array($emails)) {
$email = $sendemail["emails"];

echo "mail($email, $subject, $message, \"From: Mark <[e-mail]>\");";

$x++;
if($x == hold) { //when $x is equal to $hold, a 3 sec delay will occur to avoid timeout
sleep(3);
$x = 0;
}
} //end of while loop

?>

[naveenmedia]

Thanks. I came up with this, which also seems to work, except for one problem: I'm using various e-mail addresses to test this (so I know it goes to multiple e-mails). The problem is, it doesn't seem to go to my yahoo account. I guess I should try another yahoo account to make sure its not just a thing with my e-mail, but this would be a problem if it is not going to certain domains.

Anyway, here is the code:

<?php require_once('../Connections/lostbooksclub.php'); ?> 
<?php
mysql_select_db($database_lostbooksclub, $lostbooksclub);
$query_rs_email = "SELECT email FROM members";
$rs_email = mysql_query($query_rs_email, $lostbooksclub) or die(mysql_error());
$row_rs_email = mysql_fetch_assoc($rs_email);
$totalRows_rs_email = mysql_num_rows($rs_email);
?>

<?php
$subject = $_POST['subject'];
$message = $_POST['message'];
$x = 1;
$hold = 50; //quantity of emails sent before 3 sec delay

  while ($x <= $totalRows_rs_email) {
    $sendemail = mysql_fetch_assoc($rs_email);
  	$email = $sendemail["email"];
  	mail($email, $subject, $message, "From: Mark <[e-mail]>");  

  	$x++;
   		if($x == hold) { //when $x is equal to $hold, a 3 sec delay will occur to avoid timeout
   			sleep(3);
   			$x = 0;
   		}
  } //end of while loop 
?>

[Jona]

[font=trebuchet ms]Go get a cup of coffee, and check your Yahoo mail in about 30 minutes, because it's probably just being delayed. If it sends to any email address, it will send to them all; whether or not the mail servers receive the mail is their fault.[/font]