$qurym="SELECT * FROM referal_member WHERE `ref_cusid` = '$id' && `confirm` = '1'";
$resm=mysqli_query($con,$qurym);
$rowm=mysqli_fetch_array($resm);
Just try like this: [ if fields ( ref_cusid
and confirm
) are of INT
type, then pass values $id
and 1
without single quotes ( '
), otherwise make change as below ]
$qurym = "SELECT * FROM referal_member
WHERE `ref_cusid` = ' " . $id . "'
AND `confirm` = '1'";
$resm = mysqli_query($con,$qurym);
// check query returns something or not
if(mysqli_num_rows($resm)){
// fetch data
$rowm=mysqli_fetch_array($resm);
}
else{
// no data found
}
Please remove quotes from confirm if it is integer datatype.
$qurym="SELECT * FROM referal_member WHERE `ref_cusid` = '$id' && `confirm` = 1";
$resm=mysqli_query($con,$qurym);
$rowm=mysqli_fetch_array($resm);
print_r($rowm); // to check results.
Or If ref_cusid is also integer type.
$qurym="SELECT * FROM referal_member WHERE `ref_cusid` = $id && `confirm` = 1";
$resm=mysqli_query($con,$qurym);
$rowm=mysqli_fetch_array($resm);
print_r($rowm); // to check results.