Tom Churm ([EMAIL PROTECTED]) writes:
> hi,
>
> i've got a table collecting info from html forms. problem is, certain
> wiseguys always make multiple entries. could someone clue me in to how
> i can select the Last entry where there is a duplicate for the User
> (type text, these are email addresses), and automatically delete any
> previous entries? i'm using a column 'id' int auto_increment as my
> index: the last entry from a User will automatically have a higher id #.
Try looking at the excellent MySQL FAQ! Here's a link that may help:
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0
:)
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
