Hi Using mysql_num_row(); you can find the result count. Thanks, Muthukumar Selvarasu, Project Manager (Web Development), Webmasters Ltd. From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of snehashendure Sent: Wednesday, April 02, 2008 6:23 PM To: [email protected] Subject: [php_mysql] IDENTIFYING EMPTY MYSQL QUERY 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?" [Non-text portions of this message have been removed]
