UserGroupID value in Registration.php defaults to 0
I created my security pages and used the UserGroupID column as the username (SU_ID) to login because this value will be generated by the client and be allocated to the users who will then use it to register their membership.
I redefined the properties of this field in webassist, but whatever value entered into it, it shows '0' in the database table. Also I have amended the column type in the database table created by webassist 'pcms2_users ' to Varchar but still shows 0.
Please what have I done wrong. See the code in registration php
<div class="lineGroup">
<label for="Registration_group_SU_ID" class="sublabel" > SU ID:<span class="requiredIndicator"> *</span></label>
<div class="errorGroup"> <span id="Registration_group_SU_ID_Spry"> <span>
<input id="Registration_group_SU_ID" name="Registration_group_SU_ID" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("registration","Registration_group_SU_ID"):"")); ?>" class="formTextfield_Large" tabindex="1" onBlur="hideServerError('Registration_group_SU_ID_ServerError');">
<?php
if (ValidatedField('registration','registration')) {
if ((strpos((",".ValidatedField("registration","registration").","), "," . "1" . ",") !== false || "1" == "") || (strpos((",".ValidatedField("registration","registration").","), "," . "2" . ",") !== false || "2" == "")) {
if (!(false)) {
?>
<span class="serverInvalidState" id="Registration_group_SU_ID_ServerError">Please enter a value.</span>
<?php //WAFV_Conditional registration.php registration(1,2:)
}
}
}?>
<span class="textfieldRequiredMsg">Please enter a value.</span> </span> </span> </div>
</div>