mysql select query running okay on phpmyadmin but not with php [closed]
1
This is the mysql query 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 AND (`main`.`time` BETWEEN '2018-08-01' AND '2018-11-14') ORDER BY `main`.`ID`, `mrDate` DESC This query working perfectly on sql....but it's not working perfectly on php. it's running on php but only getting some data not the total. here describes the php codes: $fdt = $_POST['formDt']; $tdt = $_POST['toDate']; $sqlforData = "SELECT *, `main`.`email` as useremail, `main`.`ID` as `userID`, `mail_owners`.`country_code_field` as `micountry`, DA