http://csskyonline.com/phpfiles/GetLevianReps-New.php

<?php

$Host = "db391228461.db.1and1.com";
$dbName = "db391228461";
$dbUser = "dbo391228461";
$dbPass = "M@ra2Luke";


$con = mysql_connect($Host,$dbUser,$dbPass);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$db_selected = mysql_select_db($dbName, $con);
if (!$db_selected)
  {
  die ("Can\'t use test_db : " . mysql_error());
  }

$q = "SELECT u.id,
		   u.username
	FROM `nr321_users` as u
	JOIN `nr321_user_usergroup_map` as ugm ON ugm.user_id = u.id
	JOIN `nr321_usergroups` as ug ON ug.id = ugm.group_id
	WHERE ug.title = 'Levian Sales Rep'
	GROUP by u.name";
//echo $q . "<br />";
$result = mysql_query($q);

$result_array = array();

$i = 0;
while($row = mysql_fetch_row($result)){
	$result_array[$i]['id'] = $row[0];
	$result_array[$i]['rep_name'] = $row[1];
	$i++;
}

echo json_encode($result_array);

?>