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, [EMAIL PROTECTED] wrote:
Dan Brunner <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] wrote:
>
> > I need to modify some company web pages that include a form for asking

> > the
> > company departments questions, such as service dept, etc. As the forms

> > are
> > 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.) And
what
> > about 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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to