second problem is easy fix.
SELECT playersname, email FROM playersemails ORDER BY playersname
I *think* first problem is easy fix, too.
Look at the documentation:
You have the order of your arguments to mysql_query backwards. The SQL is supposed to come first. And you can simply omit the connection.
$sqldata = mysql_query($sqlget)or die("query failed: " . mysql_error());
But do note that mysql_query is now obsolete, as that doc page tells you.