Webmaster wrote: > Here's my dilema. Our website runs a quarterly prize giveaway. Currently > we have an ASP form that gathers the inputed info into a database and > then sends us an e-mail confirmation of the entry. Our rules > specifically state that only one entry is allowed per quarter. As I am > not a programmer (just a dabbler in programming) I have no idea on how > to do the following and need some help. > > What we need is a script that will check our current database against an > e-mail, last name, and first name entry. If that entry is in our > database a message pops up telling them that they have already > registered with us. If there entry is not located in our database then > the new info passes along unhindered. > > We are on a Cobalt RaQ4r with ChiliAsp 3.62 installed and are using > MySQL. > > Thanks in advance for the help. > > Sincerely, > > Stephen M. LaBar, Jr. > (770) 381-3826 > Computer Specialist > > Please Visit Our Site At: > http://www.csi-atl.com > > --------------------------------------------------------------------- > 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
add primary_key (e-mail, last name, first name) when checking the result from the db, parse the error message looking for the error string mysql generates when a primary_key is violated --------------------------------------------------------------------- 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