Mysql Query does not select Ic number

[mmarif4u]

Hi every one,
I write down the code for a page that a user enter thier
ic number with his access code(which is already in the database)
but now i am facing problem, coz without sessions i want it to confirm
tha values against the database & than go for next page where user can
enter thier other details, like fullname,email,username,h/p etc.
Is for this the sessions required.

My mysql is query is:

dbConnect('db');
 
    if ($_POST['icnumber']==''
      or $_POST['acccode']=='')  { 
         error ('One or more required fields were left blank.\\n'.
              'Please fill them in and try again.');
    }
 
 
    $icnumber=($_POST['icnumber']);
  $acccode=($_POST['acccode']);
    $sql = "SELECT icnumber,acccode FROM m_users WHERE
        icnumber = '$icnumber' AND acccode = '$acccode'";
    $result = mysql_query($sql);
     if (!mysql_query($sql)<0)
    {
        include ('add.html');
            exit;
            }
    else
    {    
        error('A database error occurred in processing your '.
              'submission.\\nIf this error persists, please '.
              'contact [e-mail].');
 
 
 
}
 

Plz any body have some idea ,
thanks.

[sashi]

Hi every one,
I write down the code for a page that a user enter thier
ic number with his access code(which is already in the database)
but now i am facing problem, coz without sessions i want it to confirm
tha values against the database & than go for next page where user can
enter thier other details, like fullname,email,username,h/p etc.
Is for this the sessions required.

My mysql is query is:

[code]
dbConnect('db');

if ($_POST['icnumber']==''
or $_POST['acccode']=='') {
error ('One or more required fields were left blank.\\n'.
'Please fill them in and try again.');
}


$icnumber=($_POST['icnumber']);
$acccode=($_POST['acccode']);
$sql = "SELECT icnumber,acccode FROM m_users WHERE
icnumber = '$icnumber' AND acccode = '$acccode'";
$result = mysql_query($sql);
if (!mysql_query($sql)<0)
{
include ('add.html');
exit;
}
else
{
error('A database error occurred in processing your '.
'submission.\\nIf this error persists, please '.
'contact [e-mail].');



}
[code]

Plz any body have some idea ,
thanks.

Hi there,

Please do not make duplicate post, i believe your problem is heard in your first post itself. Hang on till someone fine a solution for the issue. Take care.

[ronverdonk]

Firstly: you opened 3 threads about this problem in this forum! I removed 2 of them. You will not be helped any quicker, the contrary, when you double post!

Now to the question at hand: I don't see what you want. You already check if a user exists, so what else do you want to check?

Ronald :cool: