Using returned sql query values as variables

[wright67uk]

How can i put returned values from an sql query, into variables.

If the returned values from a query were; email1@com, email2@com, email3@com

how would i go about puting them into variables?

 

$value1 = (1st returned value from my sql query, in this case it would be email1@com)

$value2 = (2nd returned value from my sql query, in this case it would be email2@com)

$value3 = (3rd returned value from my sql query, in this case it would be email3@com)

 

$code = $_GET['postcode'];
$message = $_GET['message'];
$emailad = "[email protected]";
$shortcode = substr($code,0,2);
$result = mysql_query("SELECT email FROM treesurgeons WHERE postcode like '%" . $shortcode . "%' ORDER BY companyName LIMIT 3")
or die(mysql_error());  
echo "<h2>Business Names:</h2>";                     
while ($row = mysql_fetch_array( $result )) 
{
$message .= "\r\n". $row['email'] ;
}
echo nl2br ($message); 
mail( "$emailad", "Header","$message" );
echo "<br>" . "Thank you for using our mail form.";
?>
</body>
</html>

 

Thankyou for any ideas, or suggestions.

[requinix]

Is $row["email"] not working for you? Why switch to individual variables?

[wright67uk]

This is because the returned values are email addresses and i would like to put the individual variables into my mail string.

 

eg.

 

mail( "$value1, $value2, $value3", "Header","$message" );

[Muddy_Funster]

while ($row = mysql_fetch_array( $result ))

{

$message .= $row['email'].";" ;

}

should fill all your mail addresses into a format that will send.