Community discussion forum

How to check there is a particular record in database or not

• • Reply

  1 year ago

  by kausar4u

  Md Abu Kausar

  Delhi, India

  Joined 1 year ago
  In my project i have one option **Create Profile** i want to check if there is any record in database regarding this email id then give message "Profile created" otherwise Profile creation page is open how we check please give me sugession..... Regards Kausar
  Report abuse
• • Reply

  1 year ago

  by Slicksim

  Simon Cooper

  Lancaster, United Kingdom

  Joined 4 years ago
  Hi, When doing this sort of work, i tend to use a scalar value that can be cast into an integer. Something like this: select count(email_id) from profile_table where email_id=:email_id; When running that, it will return you either zero for it doesn't exist, or 1+ for it does. HTH Simon C
  Report abuse
• • Reply

  1 year ago

  by kausar4u

  Md Abu Kausar

  Delhi, India

  Joined 1 year ago
  Thanks
  Report abuse