[Resolved] Mysterious Parse Error

[cilohtac3]

Hi, I need help figuring out what's wrong with my script. I've read several tutorials and manuals and I can't find the problem. I'm out of ideas now and I'd appreciate some insight from you fine folks.

I'm getting: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /home/path/send.php on line 24

Line 24 is: $subject = "$_POST['subject']"; from the following script.

<?
$username="u";
$password="p";
$database="db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$sql = "SELECT email FROM table1";
$result = "mysql_query($sql)";
$row = "mysql_fetch_array($result)";

//data from the message.php page
$subject = "$POST['subject']";
$message = "$POST['message']";

//Send message loop
While ($row) {
$email = "$row['email']";

//Take notice that we've included $subject and $message below
mail("$email","$subject","$message","From: [e-mail]");
}

echo("Newsletter sent!");
?>

[kevinsequeira]

<?
$username="u";
$password="p";
$database="db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$sql = "SELECT email FROM table1";
$result = mysql_query($sql);
//$row = mysql_fetch_array($result);

//data from the message.php page
$subject = $_POST['subject'];
$message = $_POST['message'];

//Send message loop
While ($row = mysql_fetch_array($result)) {
$email = $row['email'];

//Take notice that we've included $subject and $message below
mail($email,$subject,$message,"From: [email][e-mail][/email]");
}

echo("Newsletter sent!");
?>

reg
kevin

[cilohtac3]

Thanks Kevin for your help.

Actually, I had tried that, as it made sense to me, but what happens when I do that is the script stalls. (When that happened, I reverted back to the original script that I posted, because at least then it gave me some info on what was wrong).

The form itself is on a page called email.php and it posts to send.php. When I fill out the form on email.php and hit the submit button, it is supposed to post to send.php, send the e-mail, and give me a notice saying "newsletter sent." But instead, what happens is I click on the submit button and it just stays there on email.php. The "throbber" and status bar in my browser indicate that it is doing something, but it seems to just stay on email.php indefinitely and never goes to send.php. There's no code on email.php other than the HTML for the form, and it's posting to the correct place: <form action="send.php" method="post">. Send.php has no other code besides what I copied above and the basic necessary HTML.

Does anyone know what would make the script stall like that? BTW there are only about 5 records in the database.

TIA

[kevinsequeira]

it stalls cause its in a infinite loop

remove this line

$row = mysql_fetch_array($result);

and replace
while($row) with while($row = mysql_fetch_array($result) )

I've made the changes to my earlier post

reg
kevin

[drag0n]

Hey Kevin
Can you explain why you did that and how it was a infinite loop? Thanks

[stolzyboy]

think about it, if you have

while($row)

when is it not while something, you need a condition to stop the while loop, thats like saying

while(1==1) //never is false

while($row = mysql_fetch_array($result))//is an array with only so many possibilities
{
do somestuff
}

[drag0n]

ahh thanks

[cilohtac3]

You guys rock, thanks. 😃