php error when trying to echo an image from an external URL

Question

Inside this picture it explains it a little better, but basically In the html column, I need to have the players Avatar from an External URL Placed next to the users name. But I cant seem to get it to work I figured I would ask here because this community is rather helpful Here's the code:

<?php
$connection = mysql_connect('REMOVED', 'REMOVED', 'REMOVED'); 
mysql_select_db('stats');

$query = "SELECT * FROM stats"; 
$result = mysql_query($query);

while($row = mysql_fetch_array($result)){   
echo "<tr><td><img src="'. "https://crafatar.com/avatars/" . $row['uuid'] .
 '">" . $row['name'] . "</td>";  
 echo "<td>" . $row['PLAYER_KILLS'] . "</td>";  
 echo "<td>" . $row['MOB_KILLS'] . "</td>";  
 echo "<td>" . $row['DEATHS'] . "</td>";  
 echo "<td>" . $row['DAMAGE_DEALT'] . "</td>";  
 echo "<td>" . $row['DAMAGE_TAKEN'] . "</td>";  
}



mysql_close(); 
?>

Answer 1

This should work:

echo "<tr><td><img src=\"https://crafatar.com/avatars/\"" . $row['uuid'] . ">" . $row['name'] . "</td>"; 

Use \" to escape "

Answer 2

PHP will interpolate variables in brackets, so you can escape the quotes in the src tag and then enclose your variables in {}:

echo "<tr><td><img src=\"https://crafatar.com/avatars/{$row['uuid']}\">{$row['name']}</td>";

No concatenation required, the code is much cleaner. Here is an EXAMPLE.

The result is:

<tr><td><img src="https://crafatar.com/avatars/42">foo</td>

WARNING

You should stop using mysql_* functions. These extensions have been removed in PHP 7. Learn about prepared statements for PDO and MySQLi and consider using PDO, it's really pretty easy.