Cfrgtkky

0 $sqlforData = "SELECT *, `main`.`email` as useremail, `main`.`ID` as `userID`, `mail_owners`.`country_code_field` as `micountry`, DATE(`main`.`time`) as `mrDate` FROM `main` LEFT JOIN `mail_owners` ON `main`.`ID` = `mail_owners`.`ID` WHERE `main`.`is_deleted` = 0 ORDER BY `main`.`ID`, DATE(`main`.`time`) DESC"; this is my query I'm fetching all the data and trying to show them by php condition like this. while ($table = mysqli_fetch_array($result)) { echo strtotime($table['mrDate']) >= strtotime($from) && strtotime($table['mrDate']) <= strtotime($to); } but this is not showing all the data as I've more then 30k data....and I can just get half of the data from my database. and I'm also getting issues is I set the from date to Augest 1, 2018. After

0 I'm trying to use the AWS CLI to confirm Cognito users (to change their status from FORCE_CHANGE_PASSWORD to CONFIRMED ). I had success doing this with an App client without and app secret, but I can't figure out how to do it in an App client that has one. According to the AWS CLI reference, here: https://docs.aws.amazon.com/cli/latest/reference/cognito-idp/admin-initiate-auth.html I should be able to do it by passing the App secret, like this: (broken up for formatting, I'm entering it as a full line) aws cognito-idp admin-initiate-auth --user-pool-id us-east-1_xxxxxxxx --region=us-east-1 --client-id xxxxxxxxxxxxxxxxxxxxx --auth-flow ADMIN_NO_SRP_AUTH --auth-parameters USERNAME=TestUser PASSWORD='Test_Password' SECRET_HASH=xxxxxxxx