Question about passing date in sql...
| From: | Payne | Date: | Wed, 01 Aug 2007 21:47:22 +0000 |
| Subject: | Question about passing date in sql... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-260031@lists.php.net to get a copy of this message | ||
Guys,
Got a quick question. I got a sql statement works when I pass it from the cli. but if I try in php I get nothing.
This is the statement.
Select ip, date, time, CONCAT(city, ', ',country) as location from ips where country !=' ' and date='
date +%Y%m%d' order by country asc;
I know it has to do with date='date +%Y%m%d', because if I remove it works.
Any clue as to why?
Payne