When i execute this query the result of oci_num_rows always zero , can any one help ?!
$sql="SELECT * FROM apps.xx_fa_by_loc_mob where site_name ='$location' AND tag_number='$data1'";
$res= oci_parse($link, $sql);
oci_execute($res);
$var=oci_num_rows($res);
echo $var;
any help would be great !!