Aleksey Ratnikov

SELECT a,Count(a) FROM A
INNER JOIN B ON B.b = A.a
WHERE ... 
GROUP BY a

$query = $db->query("SELECT name FROM MS_store WHERE name LIKE '$queryString%' LIMIT 10");

echo "</li><li onclick=\"fill( '{$result->value}');\">{$result->value}</li>";

Google все умеет

// set POST variables
$url 		= 'http://api.pleer.com/token.php';
$userpwd 	= 'testclient:testpass '; // заменить на свои данные
$fields 	= array(
	'grant_type' => 'client_credentials'
);

// url-ify the data for the POST
foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
$fields_string = rtrim($fields_string, '&');

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
curl_setopt($ch, CURLOPT_USERPWD, $userpwd);

$result = curl_exec($ch);
curl_close($ch);

print_r('<pre>' . $result . '</pre>');