@Muthukumar Selvarasu Thanx a ton
Muthukumar Selvarasu <[EMAIL PROTECTED]> wrote: 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] --------------------------------- You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. [Non-text portions of this message have been removed]
