Re: [PHP] Question about passing date in sql...

2007-08-07 Thread Richard Lynch
On Wed, August 1, 2007 5:00 pm, Michael Preslar wrote: I know it has to do with date='`date +%Y%m%d`', because if I remove it works. Are you trying to use perl's back tic operator in php here? Close. He's trying to use the shell's back tick operator in MySQL. I think. It would actually

Re: [PHP] Question about passing date in sql...

2007-08-02 Thread Payne
Stut wrote: Michael Preslar wrote: I know it has to do with date='`date +%Y%m%d`', because if I remove it works. Are you trying to use perl's back tic operator in php here? PHP also supports the that. However, I think the OP's problem is that it's inside other quotes and is therefore not

Re: [PHP] Question about passing date in sql...

2007-08-02 Thread Payne
Payne wrote: Stut wrote: Michael Preslar wrote: I know it has to do with date='`date +%Y%m%d`', because if I remove it works. Are you trying to use perl's back tic operator in php here? PHP also supports the that. However, I think the OP's problem is that it's inside other quotes and is

[PHP] Question about passing date in sql...

2007-08-01 Thread Payne
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

Re: [PHP] Question about passing date in sql...

2007-08-01 Thread Brad Bonkoski
Payne wrote: 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

Re: [PHP] Question about passing date in sql...

2007-08-01 Thread Michael Preslar
I know it has to do with date='`date +%Y%m%d`', because if I remove it works. Are you trying to use perl's back tic operator in php here? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Question about passing date in sql...

2007-08-01 Thread Stut
Michael Preslar wrote: I know it has to do with date='`date +%Y%m%d`', because if I remove it works. Are you trying to use perl's back tic operator in php here? PHP also supports the that. However, I think the OP's problem is that it's inside other quotes and is therefore not being