Sending e-mail with sql search in?

[bjblackmore]

Hi,
I have a script that sends a confirmation e-mail when a user subscribes. I have...

$message = "You have successfully registered ".
"Your username & password is".
"\n\nUser Name: $user_name ".
"\nPassword: $password1 ".
"\n\nYour current values are: - ";
$sql = "SELECT value FROM table WHERE user_id='$sUserID'";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
$value = $row['value'];
$message .= "\n$value\n ";
}
$message .= "\n\nIf you have any questions or need any help please contact me";

The trouble is, the message contains the 1st and last $message. But not the...

$message .= "\n$value\n ";

Is there something wrong?
Cheers
Ben

[Anon]

Its obvious that your sql query is not working -- not fetching the value so it doesnt go inside the loop

mandar