Hi,
In my database i have user table contains user_id,password,email.
To insert a new row i am checking for the email.if email already exists
i am generating error message the email already exist.
Here my problem is i am interacting db twice.
1.select query returns true if user exists
2.insert data if select query returns false.
But i want this should happen in a single query.
Can you tell me how to do it.
Thanks in Advance,
Raj.