insert into database and validation

[linux_super2000]

hi there, i had 2 problem that i need anyone help.

First i try insert into the users table but i cant get the result i want this is the sql statement that i try :-

$stmt = "INSERT INTO users( name, password, RealName, useraddress, nic, email, country, receiverel, tel, birthday, session, active)";
$stmt .= " values ('$nu_name', '$nu_passwd', '$nu_realname','$nu_useraddress','$nu_nic','$nu_email','$nu_country', '$nu_receiverel', '$nu_tel', '$nu_birthday',";

everything ok but i want to set the active value to Y ! how i need to do that and how i want to insert a validation in this file newuser.php code

if possible just show some sample using the same code ... i appriate to anyone who help me thank

[mykg4orce]

this may not be related to your problem but shorten your query like this:

$stmt = "INSERT INTO users VALUES (
'',
'$nu_name',
'$nu_passwd',
'$nu_realname',
'$nu_useraddress',
'$nu_nic','$nu_email',
'$nu_country',
'$nu_receiverel',
'$nu_tel',
'$nu_birthday',
'$session',
'Y'
");

you can just pass "Y" to the query directly....perhaps I misunderstood your question.

remember that the first set of '' is empty so that your ID field can auto increment.