Can anyone see what must be a simple error in the way I am trying to
construct the 2 WHERE clauses, below? (in the latter query)
These two columns in the two separate tables are of type TIMESTAMP:
solarLandingDateTime
solarAWDateTime
The values I am passing into the query are like so
var_dump(
John Butler wrote:
Can anyone see what must be a simple error in the way I am trying to
construct the 2 WHERE clauses, below? (in the latter query)
These two columns in the two separate tables are of type TIMESTAMP:
solarLandingDateTime
solarAWDateTime
The values I am passing into the query ar
read 2nd something not right.. or should show ERRORRR?? but. let's skip
it.. i think you tried it and work.. soo ignore this line.
uniqueDate??
why not order by id.. is the same right?
>>It seems super easy to me;
great.. i need 1 hour to understand this
can you include sample from those table
echo mysql_error();
You will need to quote your timestamps:
where date(solarLandingDateTime) >= '" .
mysql_real_escape_string($userPikStartDate) . "' AND
date(solarLandingDateTime) <= '" .
mysql_real_escape_string($userPikEndDate) . "'
If all else fails,
echo $query;
Than
John Butler wrote:
echo mysql_error();
You will need to quote your timestamps:
where date(solarLandingDateTime) >= '" .
mysql_real_escape_string($userPikStartDate) . "' AND
date(solarLandingDateTime) <= '" .
mysql_real_escape_string($userPikEndDate) . "'
If all else fails,
ech
