#1
  1. No Profile Picture
    Voice
    Guest
    Devshed Newbie (0 - 499 posts)
    Hi,
    I am fairly new to php3 and mysql. I would like to know how it is possible to make sure that only unique field entries can be made (ie. if the telephone number 123456 is already taken it cannot be registered again). I would much appreciate any help.
    Thanks
  2. #2
  3. No Profile Picture
    spaceman
    Guest
    Devshed Newbie (0 - 499 posts)
    A couple of options:
    1. When processing a form, consider which fields need to be validated, and what sort of validation is required. So, if telephone numbers (to use your example) must be unique, you validate this input by doing a lookup on the relevant table to see if any records exist with the same tel number, eg.
    $query ="select tel_no from addresses where tel_no=$new_tel LIMIT 1";
    $result = mysql_query($query);
    $count = mysql_num_rows($result);
    if ($count==1):
    echo "oops - duplicate tel no";
    else:
    echo "new tel is fine";
    endif;

    2. You can define a field on a MySQL table to be unique. If anyone tries to enter a duplicate, MySQL spits the dummy.


    ------------------

Similar Threads

  1. best way to send email validation
    By njcallen in forum PHP Development
    Replies: 2
    Last Post: January 28th, 2004, 10:02 AM
  2. Error checking/ validation for international address inputs
    By aalspach in forum HTML Programming
    Replies: 0
    Last Post: September 10th, 2003, 11:14 PM
  3. Errors w Form Validation
    By jsKid in forum HTML Programming
    Replies: 8
    Last Post: December 30th, 2002, 04:03 PM
  4. VBScript, form, validation, and database
    By csanchez in forum Beginner Programming
    Replies: 1
    Last Post: April 24th, 2002, 09:20 AM
  5. Quick form validation help required
    By mystik_web in forum HTML Programming
    Replies: 1
    Last Post: November 29th, 2001, 04:54 AM

IMN logo majestic logo threadwatch logo seochat tools logo