$query = mysql_query("SELECT * FROM users WHERE username = '$username' "); if(mysql_num_rows($query) > 0) { //already exists } else { //insert to db }