Hi, i am working on a member database. I need to get all the registrations except the current week. I have a "week" field in my database.
This one is fine and echos all the records from week 1 to 8:
SELECT COUNT(*) FROM agents WHERE week < 9 and status = Active
But when it transfered to a 2 digit value it returns 0 result:
SELECT COUNT(*) FROM agents WHERE week < 10 and status = Active
I've been here for sometime to no avail.
Thanks a lot guys!