<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Greetings,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Am new to list, so I just wanted to say hello and
post my first question. :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am writing a simple script right now (attached)
to allow people to register usernames/passwords into a MySQL DB.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The script works, but in the "make_handle"
subroutine, which inserts the username/passwords input to the DB, I am trying to
figure out what to do if the proposed handles already exist. How do I
notify the user of the error and to try again?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The error would occur around line 120 of the
script. Somehow I'm going to have to initialize a variable and set it into
a conditional that will allow me to post a "Success" or "Try again" statement,
but I'm not sure how to do so. I've got RaiseError working, and it
might be possible to use it somehow to set a variable equal to 1 for "Try Again"
or "0" for "Success", but if thats the answer I'm still not sure of how to write
it out.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Can anyone give me some pointers here?
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Will</FONT> </DIV></BODY></HTML>