Array?

[bjblackmore]

Hi,
I am setting up a cinfirm e-mail, for users when they register.
My $message is currently

$message = "Welcome, you have successfully registered ".
"\nYour User Name and password is: - ".
"\n$username ".
"\n$password ".
"If you have any problems, please contact me ".

After thw username & password, I want to do: -
Your current enteries are: -
$values

However I need to run a database search to do this, so it pulls all the records for that user and displays them. How do I do that? I have tried..
$sql = "SELECT value FROM test_table WHERE user_id='$sUserID'";
$result=db_query($sql);
while($row=mysql_fetch_array($result)){
$value = $row['value'];
}

Then
"\n\nYou currently have the folowing room types ".
"\n$value ".

However it doesn't display anything. Can someone help me?
Cheers
Ben

[cordex]

I would change:
$result=db_query($sql);

to
$result= mysql_query($sql);

...
but that's just me