Re: Chec db if username is already there

Thanks to everyone for the help. I do have a follow up question. I am testing this on a in-house test server, without mail. If I want to test live I have to change everything to php. Before I do that should I move the mail() after the sql to prevent it from being sent until the check for username is finished? Gary David Robley wrote: > On Thu, 19 Oct 2000, Gary wrote: > > Hello, > > I am fairly new to php and need some help. I have written a sign-up and > > need to find out if the user name and or the email address are already > > in the database. > > Just do a query on the table along the lines of SELECT COUNT(*) AS num FROM > table WHERE username = '$username' and check the returned value of num; if > it is zero the anme doesn't exist, otherwise it does. > > -- > David Robley | WEBMASTER & Mail List Admin > RESEARCH CENTRE FOR INJURY STUDIES | > http://www.nisu.flinders.edu.au/ > AusEinet | > http://auseinet.flinders.edu.au/ > Flinders University, ADELAIDE, SOUTH AUSTRALIA