i need to know if there is a member whose enrollment date is earlier than a specified date.
If this case, the specified date = $Monday
$Monday = 12-30-2009; $result = mysql_query("SELECT COUNT(*) FROM agents WHERE (sponsor = '$parent') and (lft between $leftlft AND $leftrgt) and (enrollment_date >= '$Monday')");
I tested to put a member with enrollment_date as 12-3-2009 but the this results to 0.
So tried to reset the $Monday to 12-29-2009 and returned 1 result.
What do you think is the problem with this code?