help with wesite

[dasaver]

I am having a problem i have just about everything set up for the website. when i go to make an account for my flyff server it creates the account but it only creates the account in ACCOUNT_TBL_DETAIL and not in the ACCOUNT_TBL. so every time i go to log into this new account it says that the log in is incorrect because the account isnt in the ACCOUNT_TBL.
hoping someone can help me.

[_Halloween_]

What happens, if you move it to the right path?

[dasaver]

yes i was looking for how to do that i think this is the part i need to fix.

odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$checkacc = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE account=\''.mssql_escape_string($_POST['reg_username']).'\'');
$checkmail = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL_DETAIL] WHERE email=\''.mssql_escape_string($_POST['reg_email']).'\'');
$errors = array();

but I dont know exactly what to change.

[xTwiLightx]

It depends on how the website is creating the account.
Is it using a stored procedure? -> Edit the procedure in SQL to also insert values into the ACCOUNT_TBL.
Is is using raw queries in it's code? -> Edit the code to also insert values into the ACCOUNT_TBL.

[dasaver]

I fixed it
thank you for your help.