Ricavare la provincia dal database mysql

[goikiu]

$sql="SELECT billing_state ,orders_id FROM orders WHERE orders_id=$var";
$result = mysql_query($sql);
while ($arrayh= mysql_fetch_array($result))
{
$provincia=$arrayh['billing_state'] ;
$sql2 = "SELECT zone_code FROM zones WHERE zone_name LIKE '$provincia'";
$res_parziale = mysql_query($sql2);
$res = mysql_fetch_array($res_parziale);
print ($res['zone_code']);
}