i'm developing a php forgot password script with the below 4 steps in which i need to validate userid from one table and user's addresses from other table.
i've 2 tables in my DB customers and customer_addresses.
in the first form i'm validating the form input with user ID.
my code for first form:
Code: Select all
$query="SELECT customerID FROM ss_customers WHERE Login='" . mysql_real_escape_string($Login) . "'";heres my code:
Code: Select all
$query="SELECT customerID FROM ss_customer_addresses WHERE first_name='" . mysql_real_escape_string($first_name) . "' and last_name='" . mysql_real_escape_string($last_name) . "' and state='" . mysql_real_escape_string($state) . "' and zip='" . mysql_real_escape_string($zip) . "'";can anyone please help me out..
awaiting ur reply's
many thanks,