I'm new here and new to PHP, so please take it easy on me! =]
I'm working on a php login script that would allow a user to enter their last name or their username in the username field and their password. Upon submit, check for a record with last name or username, password and expiration date is greater than todays date. I've got the username or last name and password part down and working.
Background info: the 'Expiration Date' field is a usual text field in the SQL db and i'm not going to be able to change that.
This is what i have so far:
$cur_date = date("n/j/Y");
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' or lastname='$myusername' and password='$mypassword' and 'Expiration Date' > $cur_date";
Thanks in advance everyone!