Send MYSQL rows via email

hi everyone, i see this script in your site

[code=php]<?php
include(‘connect-db.php’);
$query = “SELECT data FROM players WHERE id='”.$_GET[‘id’].”‘”;
$to = “[email protected]”;
$subject = “Your feedback, sir.”;

$result = mysql_query($query);
if($result)
{
if(mysql_num_rows($result))
{
$message = mysql_result($result, 0);
if(mail($to, $subject, $message, $headers))
{
echo “IT WORKED!!!!”;
}
else
{
echo “Sorry, there was a problem sending the email.”;
}
}
else
{
echo “Sorry, no matching data was found, email not sent.<br>”;
die(“No row returned: $query”);
}
}
else
{
echo “Sorry, there was a problem with the database–email not sent.<br>”;
die(mysql_error().”n”.$query);
}
?>[/code]

but i wnat to invie multi rows and not only data but also data2,data3,data4…. how i modified this for send multi rows?

Also in #PHP _↴