RE: [PHP] Server's clock gone funny, maybe?

2004-07-29 Thread David Robley 
On Fri, 30 Jul 2004 03:45, Matthew Sims wrote:

>>
>> [smartass mode to full power - nothing personl]
>> [/smartass mode]
> 
> Is that W3C HTML 4.01 compliant?
> 
I believe it is XNML - extended noob markup language


-- 
David Robley

Lawyers: The larval form of politicians.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Server's clock gone funny, maybe? OT

2004-07-29 Thread Jay Blanchard 
[snip]
> Please read this now, before you post again...
> http://catb.org/~esr/faqs/smart-questions.html

Thank you for not trying to be a condescending smartass at all.
[/snip]

Thank you for noticing! :-)

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Server's clock gone funny, maybe?

2004-07-29 Thread Brian Dunning 
On Jul 29, 2004, at 10:45 AM, Jay Blanchard wrote:
Please read this now, before you post again...
http://catb.org/~esr/faqs/smart-questions.html
Thank you for not trying to be a condescending smartass at all.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Server's clock gone funny, maybe? OT

2004-07-29 Thread php-general 
Quoting Jay Blanchard <[EMAIL PROTECTED]>:

> [snip]
> >
> > [smartass mode to full power - nothing personl]
> > [/smartass mode]
> 
> Is that W3C HTML 4.01 compliant?
> [/snip]
> 
> Yes, ermaybe. Try XJBML strict
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
Tag is invalid personl, should be personAl

:)


-
This mail sent through IMP: http://horde.org/imp/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Server's clock gone funny, maybe? OT

2004-07-29 Thread Jay Blanchard 
[snip]
>
> [smartass mode to full power - nothing personl]
> [/smartass mode]

Is that W3C HTML 4.01 compliant?
[/snip]

Yes, ermaybe. Try XJBML strict

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Server's clock gone funny, maybe?

2004-07-29 Thread Matthew Sims 
>
> [smartass mode to full power - nothing personl]
> [/smartass mode]

Is that W3C HTML 4.01 compliant?

-- 
--Matthew Sims
--

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Server's clock gone funny, maybe?

2004-07-29 Thread Ed Lazor 
Maybe they've upgraded something on the server that's somehow affecting your
code?

Against MySQL 4.0.18

  Query:  select NOW()
Results:  2004-07-29 10:48:12

  Query:  select NOW()+300
Results:  20040732104424


The difference in result data format would lead to the problem you're
experiencing.  In other words, you're suddenly trying to store a big number
into a date or date_time field and that doesn't work.

Depending on which version of MySQL you're using, try one of these:

(MySQL 4.1.1 and later)
update table set expire = ADDDATE(CURDATE(), 3) where ...

(older versions)
update table set expire = interval 3 day + CURDATE() where ... 




> -Original Message-
> I've got a function where I reset an expiration datetime to 3 days in
> the future, using:
> 
>update table set expire = NOW()+300 where ...
> 
> Has always worked great, but today it always sets the field to
> -00-00 00:00:00. No code was touched. Anyone have a clue? A problem
> with the ISP's server clock?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Server's clock gone funny, maybe?

2004-07-29 Thread Jason Wong 
On Friday 30 July 2004 01:39, Brian Dunning wrote:
> On Jul 29, 2004, at 10:18 AM, Jay Blanchard wrote:
> > Have you asked the ISP?
>
> No - that's like asking a black hole, unfortunately - I was hoping
> someone here might spot a problem on my end.

1) You're on the wrong list. Try asking on the mailing list of whatever DB 
you're using.

2) For date calculations it's generally a good idea to use the the DB's date 
calculation functions.

3) There are loads of things you can do yourself to help analyse the problem: 
eg what does NOW() show in DB?, what does `date` show in OS (assuming un*x), 
what does date() show in PHP?

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
"MSDOS didn't get as bad as it is overnight -- it took over ten years
of careful development."
(By [EMAIL PROTECTED])
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Server's clock gone funny, maybe?

2004-07-29 Thread Jay Blanchard 
[snip]
> Have you asked the ISP?

No - that's like asking a black hole, unfortunately - I was hoping 
someone here might spot a problem on my end.
[/snip]

[smartass mode to full power - nothing personl]
The problem most of us spotted was that there was not information in the
initial post to arrive at any conclusion whatsoever. No code was given,
because that wasn't broken. You gave us a SQL query (which might be
directed at a database list) which offered no possible explanation and
then you asked us about your ISP. Since we all knew instinctively which
ISP it was we figured it might be easier to ask them. They probably have
recompiled Apache, PHP and MySQL...depricating some of your usage.
[/smartass mode]

Please read this now, before you post again...
http://catb.org/~esr/faqs/smart-questions.html

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Server's clock gone funny, maybe?

2004-07-29 Thread Brian Dunning 
On Jul 29, 2004, at 10:18 AM, Jay Blanchard wrote:
Have you asked the ISP?
No - that's like asking a black hole, unfortunately - I was hoping 
someone here might spot a problem on my end.

- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Server's clock gone funny, maybe?

2004-07-29 Thread Jay Blanchard 
[snip]
I've got a function where I reset an expiration datetime to 3 days in 
the future, using:

   update table set expire = NOW()+300 where ...

Has always worked great, but today it always sets the field to 
-00-00 00:00:00. No code was touched. Anyone have a clue? A problem 
with the ISP's server clock?
[/snip]

Have you asked the ISP?

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Server's clock gone funny, maybe?

2004-07-29 Thread Brian Dunning 
I've got a function where I reset an expiration datetime to 3 days in 
the future, using:

  update table set expire = NOW()+300 where ...
Has always worked great, but today it always sets the field to 
-00-00 00:00:00. No code was touched. Anyone have a clue? A problem 
with the ISP's server clock?

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php