Coding Help

[russmc]

Can anybody tell me how do you compare information stored in the database with info a user inputs on a form.

lets say email_address and order_id

the user created an account so the above info is in the database already.

I create a form that allows them to enter that information again, when thay submit that form I want the code to compare what they entered to what is in the database and then direct them to another page or tell them that the information is incorrect or does not exist, try again.

Thanks

[bav]

try this:

$result = mysql_query("select order_id, email_address From ur_table_name WHERE order_id = '$order_id' AND email_address = '$email_address'");
$number = mysql_num_rows($result);
if($number) {
    echo "take them to your page";
}
else {
    echo "your info is incorrect"; 
}