$query_result1 = "SELECT a.id, a.name_id as nameid, b.id, b.firstname, b.lastname, b.enabled
FROM paintings a
LEFT JOIN artist_names b
ON a.name_id = b.id where b.enabled = 1
GROUP BY b.lastname ASC";
$result1 = mysql_query($query_result1);
$row_result1 = mysql_fetch_assoc($result1);

$myindex = 0;
while($row_result1 = mysql_fetch_array($result1)) {
	$data1[] = "<a href=\"art.php?id=".$row_result1['nameid']."\" class=LinkDarkLight>".ucwords($row_result1['lastname']).", ".ucwords($row_result1['firstname'])."</a>";
	echo "$data1[$myindex]<br/>\n";
	$myindex++;
}
die ("End of test.\n");