I'm trying to query records from a mysql table using a date range selected by user of a site, like this:
Code: Select all
$query = "SELECT * `table` WHERE (`column` BETWEEN $startdate AND $enddate) ";
Moderator: General Moderators
Code: Select all
$query = "SELECT * `table` WHERE (`column` BETWEEN $startdate AND $enddate) ";
Code: Select all
$timeStampFrom = strtotime("$fromdate");
$timeStampTo = strtotime("$todate");
$query = "SELECT * ";
$query .= "FROM `table` ";
$query .= "WHERE (`Date` BETWEEN $timeStampFrom AND $timeStampTo)";
Code: Select all
$query = "SELECT * `table` WHERE (`column` BETWEEN $startdate AND $enddate) ";
echo "SQL=$query<br>";Code: Select all
SELECT * FROM `Table` WHERE '' >= `Date` AND `Date` >= ''Code: Select all
object(DateTime)[3]
public 'date' => string '2014-03-12 00:00:00' (length=19)
public 'timezone_type' => int 3
public 'timezone' => string 'UTC' (length=3)
object(DateTime)[4]
public 'date' => string '2014-03-19 00:00:00' (length=19)
public 'timezone_type' => int 3
public 'timezone' => string 'UTC' (length=3)
Code: Select all
$query = "SELECT * `table` WHERE (`column` BETWEEN $startdate AND $enddate) ";Code: Select all
$query = "SELECT * FROM `Table` WHERE '$startdate' <= ` Column` AND `Column` <= '$enddate'";