"); for ($count = 0 ; $count < $max ; $count++) { printf("

%s",mysql_result($result,$count,"artist")); } // close the printout loop printf(""); // close the db connection to free up resources mysql_close($db); ?>