Re: [PHP-DB] mySQL date query

2010-04-13 Thread Chaitanya Yanamadala
what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I am trying to write a mySQL query on my stats table. I am trying to determine the number of records (users) during a 7 day period ending

Re: [PHP-DB] mySQL date query

2010-04-13 Thread Chris
Ron Piggott wrote: I am trying to write a mySQL query on my stats table. I am trying to determine the number of records (users) during a 7 day period ending yesterday. I always to keep it current ... Yesterday will keep changing. In other words I want to know the number of users who accessed

Re: [PHP-DB] mySQL date query

2010-04-13 Thread Ron Piggott
It is in a 'date' column type -MM-DD what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I am trying to write a mySQL query on my stats table. I am trying to determine the number of records

Re: [PHP-DB] mySQL date query

2010-04-13 Thread Chaitanya Yanamadala
try this SELECT DATE_ADD('2008-01-02', INTERVAL -7 DAY); Chaitanya On Tue, Apr 13, 2010 at 12:01 PM, Ron Piggott ron.pigg...@actsministries.org wrote: It is in a 'date' column type -MM-DD what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at

Re: [PHP-DB] Postgres - how to skip 'sequence' columns

2010-04-13 Thread Gary .
On 4/13/10, Chris wrote: Gary . wrote: Is it possible to skip column(s) in the target table when using pg_copy_from? ... It seems not from looking at the php manual. You could use http://www.php.net/manual/en/function.pg-put-line.php instead. Yeah. I was hoping to use pg_copy_from to avoid

[PHP-DB] Fatal error: Call to undefined function pq_query()

2010-04-13 Thread Gary .
What the... What is causing this? I can use pg_connect without complaint, why does pq_query give this problem? PHP 5.3.1 FWIW. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fatal error: Call to undefined function pq_query()

2010-04-13 Thread Firan Corneliu
Are you sure you're not using q instead of g :) just to be sure, you can check if a function exists by using $boolExists = function_exists('any_function_name'); http://www.php.net/manual/en/function.function-exists.php On Tue, Apr 13, 2010 at 11:20 AM, Gary . php...@garydjones.name wrote:

Re: [PHP-DB] Fatal error: Call to undefined function pq_query()

2010-04-13 Thread Gary .
On Tue, Apr 13, 2010 at 10:40 AM, Firan Corneliu wrote: Are you sure you're not using q instead of g :) Err. My first thought was What a strange thing to ask. Then I looked... Thanks. I'd been looking at that for a good hour or so... *embarrassed* -- PHP Database Mailing List

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-04-13 Thread Taygun ALBAN
so the topic is dead? -- Taygun ALBAN IT Manager Creativity Talent Information Technologies

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-04-13 Thread Gunawan Wibisono
well... i don't have idea and suddenly have busy in my work On Wed, Apr 14, 2010 at 6:43 AM, Taygun ALBAN taygun.al...@gmail.comwrote: so the topic is dead? -- Taygun ALBAN IT Manager Creativity Talent Information Technologies -- akan ada dimana mulut terkunci dan suara tak ada