Your query looks fine. Use these statements to execute the query and get the count:
$result = mysql_query($myquery);
$rowCount = mysql_num_rows($result);
If($rowCount !=0){
echo "NOT EMPTY";
}else{
echo "EMPTY";
}
To FREE up the result:
mysql_free_result($result);
2
solved Using mysql query and result in php? [closed]