Re: address info, forms, maintanance
| From: | Miles Thompson | Date: | Wed, 04 Jun 2003 20:44:08 +0000 |
| Subject: | Re: address info, forms, maintanance | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28319@lists.php.net to get a copy of this message | ||
Chip,
What's the database being used for then, if not to store and track questions and replies? If only as a repository of addresses that 's rather useless.
Unless you want to track the frequency of user's questions, then you could update a counter field for their email address.
If you've not gone down the road too far with this, there are some help desk type PHP solutions out there.
Miles
At 01:30 PM 6/4/2003 -0700, chip.wiegand@simrad.com wrote:
Dan Brunner <daniel.brunner@duni.com> wrote on 06/04/2003 01:24:13 PM: Hello!! Are talking about the same "Post Question"??? On another words, what is being duplicated?? If not, you can use auto_increment. Dan This pertains to every time a person visits the page and fills in the form - today, tommorrow, next week, next month, whenever. The address info is being written to the database each time they send the form. The message body itself isn't saved to the database, only the name and address info. -- Chip On Wednesday, June 4, 2003, at 03:13 PM, chip.wiegand@simrad.com wrote:I need to modify some company web pages that include a form for askingthe company departments questions, such as service dept, etc. As the formsare currently built there is some field validation but no cookies. This info is saved in a mysql database, problem is, there are duplicate entries, every time an end-user posts a question. What kind of code do I need to add to these existing pages to prevent duplicate entries in the database? (Manually scanning through and deleting dupes is a real drag.) Andwhatabout cookies? Could I make use of these on these pages? I haven't worked with cookies yet, so am not sure where to start with that part. Thanks, -- Chip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php