Ytukyg

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`, 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 '$fdt' AND '$tdt') ORDER BY `main`.`ID`, `mrDate` DESC";



$result = mysqli_query($conn, $sqlforData);

while ($table = mysqli_fetch_array($result)) {

  //Showing just limited data...

}

Please help me to sort out the problem.

Thank you.

could be you have some quote and conversion issue try using str_to_date and for avoid sqlinject and comversion problem to try using prepared statement and binding param eg:

    $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 AND (`main`.`time` BETWEEN STR_TO_DATE(?, '%Y-%m%d')  

                        AND STR_TO_DATE(?, '%Y-%m%d')) 

    ORDER BY `main`.`ID`, `mrDate` DESC";





    $stmt = $mysqli->prepare($sqlforData);

    $stmt->bind_param('ss', $fdt, $tdt, );



    $stmt->execute();