causes endless while...

[raffael3d]

I have this script, it should send the mailing list list content to the subscribded people. altough there is only one email address in the database it calcualtes endless...what is wrong ?

$sql = "SELECT email_addr FROM subscribers";
$result = "mysql_query($sql)";
$row = "mysql_fetch_array($result)";
//data from the message.php page
$subject = "$subject";
$message = "$message";
//Send message loop
print $result;
	While ($row) {
	$email = "$row['email_addr']";

mail("$email_addr","$subject","$message","From: [email]asdf@asdfa[/email]"); }
echo("Newsletter sent!");

[Loafin]

Once $row has been set it has a value other than false. Nothing acts on $row to make it return a value of 'false'. As long as it evaluates to true it will loop.

try using

while ($row = "mysql_fetch_array($result)";){
loop this
}

[dopey]

Hi,
You have your function calls enclosed in quotes, e.g.

$result = "mysql_query($sql)";
$row = "mysql_fetch_array($result)";

what you prob. meant was

$result = mysql_query($sql);
$row = mysql_fetch_array($result);

still, your script will still loop continuously as mysql_fetch_array() only fetches the first row of a result. You have to call this in some sort of loop e.g.

while($row = mysql_fetch_array($result))
{
...
}

[Loafin]

Good call on the quotes... I completely missed that 🙂