My site has a feature that one user can own multiple products with one email.
Ex. Item 1 = username1 + email 1
Item 2 = username2 + email 1
Item 3 = username3 + email 1
I need the forgot email to add the extra condition to check the username before looking up the email, otherwise it says there are mutilple records for that email address.
I tried editing the trigger sql WHERE stment but it ignored it and returned the same. (it was my fault not the code obviously)
most of this is a little over my head but I "get it" with some good direction.
If someone has modified this funtion for this additional filter can you please share it?
Modify the WHERE in the query and add a variable for post username so username entered in form will be queried against database along with email etc.
I did end up doing something similar, thanks!