Re[2]: [PHP] MySQL query not working!

2010-03-31 Thread Andre Polykanine
Hello Parham, I know what the @ operator does (it stops PHP from reporting errors and makes it ignore error_reporting() or any INI directives) but I don't understand why to use it here, with mysql_query() function. -- With best regards from Ukraine, Andre Skype: Francophile; Wlm&MSN: arthaelon @

Re[2]: [PHP] MySQL query

2004-01-12 Thread Richard Davey
Hello Ashley, Monday, January 12, 2004, 8:43:07 PM, you wrote: AMK> Assume I don't know what those dates are. I need to search based on AMK> whatever the current date is, and search between 2 and 7 days back. The AMK> dates in my previous post were simply an example. Somewhat important fac

Re: Re[2]: [PHP] MySQL query

2004-01-12 Thread CPT John W. Holmes
From: "Richard Davey" <[EMAIL PROTECTED]> > RD> SELECT whatever FROM table WHERE date_column_name BETWEEN '2004-01-09 > RD> 00:00:00' AND '2004-01-04 23:59:59' > > Actually sorry, inverse the seconds (put the 00:00:00 onto the lower > date, the 4th) so it encompasses the whole period. You might a

Re[2]: [PHP] MySQL query

2004-01-12 Thread Richard Davey
RD> SELECT whatever FROM table WHERE date_column_name BETWEEN '2004-01-09 RD> 00:00:00' AND '2004-01-04 23:59:59' Actually sorry, inverse the seconds (put the 00:00:00 onto the lower date, the 4th) so it encompasses the whole period. You might actually be able to not even include the seconds, try