$sql_insert1 = "INSERT INTO `agent_users`
  			(`user_name`,
			 `password`,
			 `primary_email`,
			 `secondary_email`,
			 `join_date`,
			 `last_accessed`,
			 `activation_code`,
			 `first_name`,
			 `last_name`,
			 `license_num`,
			 `agent_dob`
			 )
			VALUES
			('$data[user_name]',
			 '$md5pass',
			 '$usr_email',
			 '$data[secondary_email]',
			 'now()',
			 'date()',
			 '$activ_code',
			 '$data[first_name]',
			 '$data[last_name]',
			 '$data[license_num]',
			 '$dob'
			 )";
 
	$sql_insert2 = "INSERT INTO `agent_company`
			(`exp_age_yr`,
			 `exp_age_mo`,
			 `exp_sales`,
			 `exp_sSales`,
			 `exp_reo`,
			 `exp_propmngt`,
			 `exp_foreclosures`,
			 `exp_lMods`,
			 `exp_bpo`,
			 `exp_commreal`,
			 `company_name`,
			 `company_address`,
			 `company_suite`,
			 `company_city`,
			 `company_state`,
			 `company_zip`,
			 `company_tel`,
			 `company_tel_ext`,
			 `company_fax`,
			 `company_web` 
			)
		    VALUES
			('$data[exp_age_yr]',
			 '$data[exp_age_mo]',
			 '$chkbx_results[exp_sales]',
			 '$chkbx_results[exp_sSales]',
			 '$chkbx_results[exp_reo]',
			 '$chkbx_results[exp_propmngt]',
			 '$chkbx_results[exp_foreclosures]',
			 '$chkbx_results[exp_lMods]',
			 '$chkbx_results[exp_bpo]',
			 '$chkbx_results[exp_commreal]',
			 '$data[company_name]',
			 '$data[company_address]',
			 '$data[company_suite]',
			 '$data[company_city]',
			 '$data[ompany_state]',
			 '$data[company_zip]',
			 '$data[company_tel]',
			 '$data[company_tel_ext]',
			 '$data[company_fax]',
			 '$data[company_web]'
			)";
 
	mysql_query($sql_insert1,$link) OR die("Insertion Failed:" . mysql_error());
	$user_id = mysql_insert_id($link);  
	$md5_id = MD5($user_id);
	mysql_query("UPDATE `agent_users` SET md5_id='$md5_id' WHERE id='$user_id'");
 
	mysql_query($sql_insert2,$link2) OR die("Insertion Failed:" . mysql_error());
	$user_id2 = mysql_insert_id($link);  
	//$new_id = mysql_query("SELECT `id` FROM `agent_users` WHERE id='$user_id'");
	mysql_query("UPDATE `agent_company` SET company_id='$user_id'");