table's field values in ARABIC showing as question Marks

[shereifes]

hi,see the query & code below,

 

1. rtm_name_arb is a field in the table storing names in ARABIC, when the query run directly on the query browser, names appears in arabic. when it is accessed from php, it shows question marks only.

 

2. if we assign some arabic value directly into this variable - $TO_ADRS_A

it works correctly.

 

help me immediately.

 

 

$pdf->SetFont("almohanad", "", 18);

 

 

$query = "SELECT bk_desc,bg_desc,rcd_floor_no,rcd_prem_desc_eng,

rtm_name_eng,rtm_name_arb,rcm_contact_person,rcm_contr_year,rcm_contr_no,

rtm_phone_off_1,rtm_phone_off_2,

DATE_FORMAT(rcm_start_date,'%d-%m-%y') as rcm_start_date,

DATE_FORMAT(rcm_expiry_date,'%d-%m-%y') as rcm_expiry_date,

DATE_FORMAT(DATE_SUB(rcm_expiry_date, INTERVAL 7 DAY),'%d-%m-%y') as rcm_fnl_date,

rcm_tot_contr_value

FROM res_contract_master cm

LEFT JOIN res_tenant_master tm ON cm.rcm_tenant_no=tm.rtm_tenant_no

LEFT JOIN res_contract_details cd ON cm.rcm_contr_year=cd.rcd_contr_year AND cm.rcm_contr_no=cd.rcd_contr_no

LEFT JOIN es_blocks bm ON cd.rcd_block_no=bm.bk_Id

LEFT JOIN es_buildings bu ON cd.rcd_building_no=bu.bg_Id

WHERE rcm_contr_year=2007 and rcm_contr_no<100";

 

$result = mysql_query($query);

 

if($row = mysql_fetch_array($result, MYSQL_ASSOC))

{

$TO_ADRS_E = $row['rtm_name_eng'];

$TO_ADRS_A = $row['rtm_name_arb'];

}

 

$TO_ADRS_A="لبب سبتسيبس الايسباسيب";

 

$x=10; $y=60;

$pdf->SetXY($x,$y); $pdf->Cell(0,4,'TO: ' . $row['rtm_name_arb'],0,0,'L');

 

$pdf->SetXY($x,$y); $pdf->Cell(0,4,'TO: ' . $TO_ADRS_A,0,0,'L');