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;
Thanks Chris!
You were right, I just needed to quote those incoming date form input
values.
I was trying to alert myself to any errors with this:
$foundUniqueDateDirROWS = mysql_query($query) or die("query failed:
" .mysql_error());
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...
Anyway now my script is happy/working!
-John
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
