Registration Check

[DA2-Ricky]

Ok, I'm working on building a membership type thing.

I have it working, but I have people reregistering the same name.

How can I check to see if the name is already in use?

Here is some of my code...

<?php
  if($submit == "Register") {
 {
   if($racer == "") {
echo "Please put a valid racer name.";
}
elseif($car == "") {
echo "Please choose a unique password.";
}
elseif($contact == "") {
echo "If you win, we have no way to contact you. Please put a contact method.";
}
else { 

include('register_user_data.php');
}
echo "You've registred to race!";
}
?>
<?
}
?>

Table name = tournament. Database name= gotglit.

Please help. 😕

[lazzerous]

you can do this in your mysql table

make the username field type 'unique'

create table users (
username varchar(15) unique,
etc