i have the following code on a link that shows people in my DB. The problem is that this shows people that day.
I want people who within the last week, so the NOW is wrong. Im having difficulty with the timing here.
i beleive the issue is here: $value_key_2 = " AND frm_users.joindate=NOW() ";
/ THIS VARIABLE LOOKS FOR MEMBERS WHO HAVE JOINED TODAY /
if(isset($GET['find_new']) && $GET['find_new'] == 1 || isset($REQUEST['find_new']) && $REQUEST['find_new'] == 1){
if(isset($GET['find_new'])){
$find_new =$GET['find_new'];
}else{
$find_new =$_REQUEST['find_new'];
}
$value_key_2 = " AND frm_users.joindate=NOW() ";
}else{
$value_key_2 = ""; $find_new="";
}
