Basically the search is finding any dates within a date range for a particular body part for the user
Code: Select all
$partQuery = mysql_query("SELECT DateEntered, $part FROM indBody WHERE MemberID = '$id' AND DateEntered >= DATE_SUB(CURDATE(), INTERVAL '$view' DAY) AND CURDATE() ORDER BY DateEntered");
$count = mysql_num_rows($partQuery);
echo "count is : ". $count;