SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
-
Jan 26, 2005, 01:29 #1
- Join Date
- Aug 2004
- Location
- san diego
- Posts
- 26
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Formpage validation returns an auto responded email
Hi folks
Based on another thread in this forum (see the code beneth). I've a twist on this one and wonder if someone have an answer to solve this. I hope this post is in right forum. It is both PHP and MySQL related. Anyway here it goes..
Code:SELECT * FROM myTable WHERE active = '1' AND ( fname LIKE '%#FORM.search#%' OR sname LIKE '%#FORM.search#%' OR company LIKE '%#FORM.search#%' )
Question 2, is totally another issue but I give you a chance to figure this one out aswell: When I submit my form and save the info to the database and if it still missing information in certain fields. I want it to send an auto responded email request to the client and inform them that certain information is missing and needs to be send in for a complete submission.
wow..hhu..headache.. did you got that? Can't explain it more clear than this.
Any help or ideas to pointing me in right direction would be very appreciated. Thanks
/rz
-
Jan 26, 2005, 07:21 #2
-
Jan 26, 2005, 12:10 #3
- Join Date
- Aug 2004
- Location
- san diego
- Posts
- 26
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Dave,
I saw your solution with an active enum or not and based on the result makes an action, which is a brilliant solution. Thank you so much. I also know that the auto respond email based on the active or/not result is an PHP thing.
But, what about my Question 2? What if you have a textfield or datetime? I'm sorry if I can't see that your solution solves that aswell.
/rz
Bookmarks