weird insert issue

[jasondavis]

I have this code below it works well most the time lik 98% of the time but the other 2% of the time the password field gets inserted into my DB as null (empty) any ideas what could cause this? Also is there a way to populate all these null values for password field with a value? When I search in phpmyadmin for blank it returns nothing

 $password_temp=base64_encode($password);
  $insert="INSERT INTO friend_reg_user (email, username, fname, lname, password, country, zip, city, gender, dob, disp_name, submit_date, uniqid, status,usstate,othstate,IP_ADD) VALUES ('$email', '$username', '$fname', '$lname', '$password_temp', '$country', '$zip', '$city', '$gender', '$dob', '$fname', now(), '$uniqid', 'Active','$usstate','$othstate','$LOCALIP')";
executeQuery($insert);

[kkobashi]

Either

1) In your mysql schema, set the default values for each field
2) You set the default value prior to SQL INSERT

Its up to you to check that data and make sure that what you are inserting into the database is valid.

[NogDog]

As Kkobahi stated, you need to validate all user inputs before inserting them. In addition, though, if a column is required in your database table, then it should have the NOT NULL attribute assigned to it as part of its definition.