HEy ppl,
I am doing a task were i need to check whether a person
requesting services is a valid employee. The details of the requesting
person are stored in table "REQUEST" and the employee db is
in "EMPLOYEE".
For verifying individual requests I have to check if a given
empid in REQUEST is present in EMPLOYEE.
What I thought of doing is that i store the empid from Request in a var
temp and then execute the query :
$query=select empid from EMPLOYEE where empid ==temp;
If the empid in REQUEST is not present in EMPLOYEE I get an empty query
my doubt is
"HOW DO I IDENTIFY THAT THE QUERY RESULT IS EMPTY?"
