Re: [PHP-DB] Date problem

At 12:26 PM 1/21/2007, Denis L. Menezes wrote: Dear friends. I have a date field in mysql called event_end . I want to run a query to find all records where the event_and is greater than today's date. I have written the following code. It does not work. Please point out the mistake. $today =

Re: [PHP-DB] Date problem again ;-)

I suppose there is a submit_time field in your DB table, so you could: SELECT * FROM `tablename` WHERE `submit_time`=.lastdays(3) lastdays() is a function you could create using mktime(),time(), and date() On Tue, 22 Mar 2005 16:28:39 -0500, Chris Payne [EMAIL PROTECTED] wrote: Hi there

RE: [PHP-DB] Date problem: data is current as of yesterday

-Original Message- From: Karen Resplendo To: [EMAIL PROTECTED] Sent: 02/07/04 19:36 Subject: [PHP-DB] Date problem: data is current as of yesterday The database queries all the sources at night after everyone has gone home. That means the data was current as of yesterday. This little

Re: [PHP-DB] Date problem: data is current as of yesterday

accidentally replied only to karen. The database queries all the sources at night after everyone has gone home. That means the data was current as of yesterday. This little snippet below returns yesterday's date, except that the first day of the month returns 0 for the day. Now, I know why

Re: [PHP-DB] date problem in MySQL DB

From: Angelo Zanetti [EMAIL PROTECTED] This might be slightly off topic but hopefully someone can help. I have a field that is a varchar and I stored dates in it. But now I want to change the type of the column to date, but I have a problem that the formats differ: my format: mm/dd/

RE: [PHP-DB] date problem in MySQL DB

Hi Angelo Yes you will have to reformat and he is something that may help you. Hope it does function dateCheckMysql ($date) { list($dateDay, $dateMonth, $dateYear) = explode(/, $date); if ((is_numeric($dateDay)) (is_numeric($dateMonth))

Re: [PHP-DB] date problem in MySQL DB

Brett King wrote: Hi Angelo Yes you will have to reformat and he is something that may help you. Hope it does function dateCheckMysql ($date) { list($dateDay, $dateMonth, $dateYear) = explode(/, $date); if ((is_numeric($dateDay)) (is_numeric($dateMonth))

RE: [PHP-DB] Date problem

snip // Do some number crunching here // $newnow = $now-$numweeks; echo $now; $converted_date = date(d-m-y,$now); echo br$converted_date; /snip You should be running your $convewrted_date on $newnow, not $now Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876

Re: [PHP-DB] date problem

maybe you should try if($date!==-00-00) {do something} Dl Neil [EMAIL PROTECTED] wrote in message 0df801c1cb3d$c947e420$c200a8c0@jrbrown">news:0df801c1cb3d$c947e420$c200a8c0@jrbrown... Rehab, i have an input field in a form that accept date called $date and in databse i made it of type

RE: [PHP-DB] Date problem

i get $postdate from my mysql database,the problem is that i want to increase that date by 6 months?? its stored in mysql as date field http://www.mysql.com/doc/D/a/Date_and_time_functions.html check DATE_ADD :) hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] date problem

Rehab, i have an input field in a form that accept date called $date and in databse i made it of type $date so its defualt is -00-00 the problem is when i say: if($date!=-00-00) {do something} he doesn't understand $date!=-00-00 Please copy-paste the actual error message.

RE: [PHP-DB] date problem

if( strcmp($date,-00-00) ) { do something} -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 12:16 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] date problem i have an input field in a form that accept date called $date and in databse i made it

RE: [PHP-DB] Date problem with new year

No bug, mate. Post your code so that we can help ya... -Original Message- From: Faye Keesic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 8:56 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Date problem with new year I have a db site that always displays the most recent

Re: [PHP-DB] Date problem with new year

Did you convert the dates to PHP's Julian format before subtracting? On Wed, 2 Jan 2002, Faye Keesic wrote: I have a db site that always displays the most recent occurrence of news stories The last occurrence of stories was last year (2001-12-31) and up to the new year rolling over, I

Re: [PHP-DB] Date problem with new year

PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Date problem with new year Ah... the $datetoget = ($datetoget-1) is the problem. Convert the Gregorian Ymd date to Julian, subtract 1, then convert the Julian date back to Gregorian (or Hebrew ;-). I've not had much success with MySQL's date