Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
create table avatari (avatarName varchar(255));
insert into avatari values ('robert.smith@hg.osgrid.org:80');
<?php
$dbconnect = &$mysqli;
$query = mysqli_query(
$dbconnect,
"SELECT avatarName FROM avatari order by avatarName"
) or die (mysqli_error($dbconnect));
while ($row = mysqli_fetch_array($query)) {
[$name, $host] = explode('@', $row['avatarName']);
echo
"<tr>
<td>{$host}</td>
</tr>\n";
}