+----------------------+---------------+
| Field                | Type          |
+----------------------+---------------+
| fullname             | varchar(60)   |
| address              | text          |
| country              | varchar(60)   |
| emailaddress         | varchar(100)  |
| gender               | enum('F','M') |
| dateofbirth          | date          |
| group_name           | varchar(30)   |
| group_type           | varchar(30)   |
| looking_for          | varchar(255)  |
| username             | varchar(10)   |
| pword                | varchar(10)   |
| newsletter_subscribe | enum('Y','N') |
| referrer_url         | varchar(255)  |
+----------------------+---------------+

<?php
// snip
// pre-validation filters come here
$obj_registration_form->applyFilter('__ALL__', 'trim');
// snip
?>

<?php
// snip
// validate form
if($obj_registration_form->validate()) {
  
  // post-validation filters come here
  $obj_registration_form->applyFilter('__ALL__', 'addslashes');
  $obj_registration_form->applyFilter('__ALL__', 'htmlentities');
  $obj_registration_form->applyFilter('txtAddress', 'nl2br');
  
  // invoke the "store_user_info" function to store the user information
  $obj_registration_form->process('store_user_information', false);    
  
  // exit the script, on successful insertion
  header('Location: ./success.php');
}
// snip
?>

<?php
// snip
// custom function to store user information into the database
function store_user_information($ary_artist_info) {
  
// store information in the database
  $connection = mysql_connect('localhost', 'guest', 'pass') or die ('Unable to connect!');
  
      mysql_select_db('db2') or die ('Unable to select database!');
      
      $query  = " INSERT INTO `users` ( `fullname` , `address` , `country` , `emailaddress` , `gender` , `dateofbirth` , `group_name` , `group_type` , `looking_for` , `username` , `pword` , `newsletter_subscribe`, `referrer_url` )";
      $query .= " VALUES ('".implode(" ", $ary_artist_info['txtFullName'])."', '".$ary_artist_info['txtAddress']."', '".$ary_artist_info['ddlCountry']."', '".$ary_artist_info['txtEmailAddress']."', '".$ary_artist_info['radGender']."', '".implode("-", $ary_artist_info['txtDateOfBirth'])."', '".$ary_artist_info['txtGroupName']."', '".$ary_artist_info['radGroupType']."', '".implode(",", $ary_artist_info['ddlLookingFor'])."', '".$ary_artist_info['txtUsername']."', '".$ary_artist_info['txtPassword1']."', '".(isset($ary_artist_info['chkNewsletter']) ? "Y" : "N")."', '".$ary_artist_info['txtReferrer']."');";
    
      $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
    
      mysql_close($connection);
}
// snip
?>