John Butler wrote:
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,
You were right, I just needed to quote those incoming date form input
I was trying to alert myself to any errors with this:
$foundUniqueDateDirROWS = mysql_query($query) or die("query failed: "
but it did not catch it. The query apparently worked.. just did not
return any rows.
then copy it to mysql (either command line or something like
phpmyadmin) and run it. What do you get?
I know I need to duplicate the remote setup here on my local dev
machine... but I have not done it. and being daunted by server admin
stuff I have never even tried to run mysql from the command line. I do
not know about phpadmin. I doubt it is available on the remote server
I am working on (it's a newbie friend's box, not a shared host). I
would ask for some clues but for all I know phpadmin is not only OT
here, but also easy to educate myself more about before I take more of
your time. I assume there is loads on google, etc...
If you're using windows, it's very easy.
It has a webserver (apache), mysql, phpmyadmin + a bunch of other stuff
included in the one download. One click installer .. voila.
Postgresql & php tutorials
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php