Re: [PHP-DB] adding a simple WHERE clause to this MySQL query causes the result to contain 0 rows?!

2009-08-10 Thread John Butler
just need to know what is this, and where to install/ learn about it, and why- phpMyAdmin (3.2.0.1) John Butler (Govinda) govinda.webdnat...@gmail.com

Re: [PHP-DB] adding a simple WHERE clause to this MySQL query causes the result to contain 0 rows?!

2009-08-09 Thread John Butler
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

[PHP-DB] adding a simple WHERE clause to this MySQL query causes the result to contain 0 rows?!

2009-08-09 Thread John Butler
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(

Re: [PHP-DB] Re: "COUNT() returns 0 if there were no matching rows." .... really?!

2009-08-07 Thread John Butler
m was the way I was building the array inside the while {} after the query, and also my lack of resetting the counter vars to 0 on each iteration of the date array. (not that anyone was bothering with this thread any more.. but just in case...) John Butler (Govinda) govinda.web