FUDforum: comp.lang.php » problem saving date fields

Home » Imported messages » comp.lang.php » problem saving date fields

Show: Today's Messages :: Polls :: Message Navigator

Re: problem saving date fields [message #174087 is a reply to message #174086]

Sat, 21 May 2011 09:29

Luuk
Messages: 329
Registered: September 2010

Karma:

Senior Member

On 21-05-2011 10:34, Co wrote:
> On 21 mei, 09:57, Luuk <L...@invalid.lan> wrote:
>> On 21-05-2011 00:52, Co wrote:
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>> On 21 mei, 00:24, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>>>> On 5/20/2011 5:00 PM, Co wrote:
>>
>>>> > I get a "1" as result.
>>>> > Don't know what you mean with this.
>>>> > Problem is that the date is set to 00-00-0000.
>>>> > Is that because there is a default set in the field (00-00-0000)?
>>
>>>> > Marco
>>
>>>> As a result for what? There's no thread here.
>>
>>>> Please use REPLY to a message, not start a new thread. And quote the
>>>> appropriate parts of the message, to maintain continuity.
>>
>>>> --
>>>> ==================
>>>> Remove the "x" from my email address
>>>> Jerry Stuckle
>>>> JDS Computer Training Corp.
>>>> jstuck...@attglobal.net
>>>> ==================
>>
>>> Luuks thought:
>>> print $sql;
>>
>>> it returns 1, dont know what I should do with it.
>>> Problem is that if I only change one of the dates:
>>> arrival_date='$arrival_date',departure_date='$departure_date'
>>
>>> the other one gets to be the default value 00-00-0000.
>>
>>> Marco
>>
>> Ok, i responded in the other thread, but wanted to 'add' this:
>>
>> 09:53:29 root@test[14]mysql> insert into testDate values ('21-05-2011');
>> Query OK, 1 row affected, 1 warning (0.00 sec)
>>
>> 09:55:46 root@test[15]mysql> select * from testDate;
>> +------------+
>> | SepDate |
>> +------------+
>> | 0000-00-00 |
>> | 2011-05-21 |
>> | 0000-00-00 |
>> +------------+
>> 3 rows in set (0.00 sec)
>>
>> --
>> Luuk
>
> Luuk,
>
> forgive me but an I a newbie.
> Where do I need to add quotes?
> And what does your tests say?
>
> Marco

Sorry, two seconds after my post i did see you gave quotes around the
dates.

Only help i can give if you copy paste the output of print $sql here.
If that gives "0000-00-00" (or another wrong date) than something is
wrong in a piece of code you did not show here.....

--
Luuk

Report message to a moderator

[Message index]

		problem saving date fields By: Co on Fri, 20 May 2011 18:38
		Re: problem saving date fields By: Luuk on Fri, 20 May 2011 18:50
		Re: problem saving date fields By: Co on Fri, 20 May 2011 21:00
		Re: problem saving date fields By: Jerry Stuckle on Fri, 20 May 2011 22:24
		Re: problem saving date fields By: Co on Fri, 20 May 2011 22:52
		Re: problem saving date fields By: Jerry Stuckle on Sat, 21 May 2011 02:30
		Re: problem saving date fields By: Luuk on Sat, 21 May 2011 07:57
		Re: problem saving date fields By: Co on Sat, 21 May 2011 08:34
		Re: problem saving date fields By: Luuk on Sat, 21 May 2011 09:29
		Re: problem saving date fields By: Co on Sat, 21 May 2011 12:12
		Re: problem saving date fields By: Luuk on Sat, 21 May 2011 13:46
		Re: problem saving date fields By: Luuk on Sat, 21 May 2011 14:02
		Re: problem saving date fields By: Co on Sat, 21 May 2011 14:09
		Re: problem saving date fields By: Luuk on Sat, 21 May 2011 14:34
		Re: problem saving date fields By: Jeff North on Fri, 20 May 2011 22:58
		Re: problem saving date fields By: Jerry Stuckle on Sat, 21 May 2011 02:35
		Re: problem saving date fields By: Jeff North on Sat, 21 May 2011 03:13
		Re: problem saving date fields By: Co on Sat, 21 May 2011 06:47
		Re: problem saving date fields By: Co on Sat, 21 May 2011 07:18
		Re: problem saving date fields By: Luuk on Sat, 21 May 2011 07:54
		Re: problem saving date fields By: Jerry Stuckle on Sat, 21 May 2011 14:37
		Re: problem saving date fields By: Co on Sat, 21 May 2011 15:07
		Re: problem saving date fields By: Jerry Stuckle on Sat, 21 May 2011 23:55
		Re: problem saving date fields By: Co on Sun, 22 May 2011 21:20
		Re: problem saving date fields By: Jerry Stuckle on Sun, 22 May 2011 21:28
		Re: problem saving date fields By: Jerry Stuckle on Sat, 21 May 2011 14:32
		Re: problem saving date fields By: Jeff North on Sat, 21 May 2011 16:08
		Re: problem saving date fields By: Jerry Stuckle on Sun, 22 May 2011 00:01
		Re: problem saving date fields By: Twayne on Sun, 22 May 2011 00:30
		Re: problem saving date fields By: Jerry Stuckle on Sun, 22 May 2011 03:13
		Re: problem saving date fields By: Jeff North on Sun, 22 May 2011 04:28
		Re: problem saving date fields By: Thomas 'PointedEars' on Sun, 22 May 2011 10:45
		Re: problem saving date fields By: Jerry Stuckle on Sun, 22 May 2011 12:26
		Re: problem saving date fields By: Twayne on Sun, 22 May 2011 13:20
		Re: problem saving date fields By: Jeff North on Sun, 22 May 2011 14:08
		Re: problem saving date fields By: Jerry Stuckle on Sun, 22 May 2011 17:47
		Re: problem saving date fields By: me on Sun, 22 May 2011 18:17
		Re: problem saving date fields By: Jerry Stuckle on Sun, 22 May 2011 18:26
		Re: problem saving date fields By: me on Sun, 22 May 2011 20:27
		Re: problem saving date fields By: Jeff North on Sun, 22 May 2011 23:01
		Re: problem saving date fields By: Jerry Stuckle on Mon, 23 May 2011 00:21
		Re: problem saving date fields By: me on Mon, 23 May 2011 01:36
		Re: problem saving date fields By: Jerry Stuckle on Mon, 23 May 2011 01:46
		Re: problem saving date fields By: Jeff North on Mon, 23 May 2011 02:20
		Re: problem saving date fields By: Jerry Stuckle on Mon, 23 May 2011 02:30
		Re: problem saving date fields By: Co on Mon, 23 May 2011 04:51
		Re: problem saving date fields By: Jerry Stuckle on Mon, 23 May 2011 11:13
		Re: problem saving date fields By: Co on Mon, 23 May 2011 17:18
		Re: problem saving date fields By: Co on Mon, 23 May 2011 17:27
		Re: problem saving date fields By: Jerry Stuckle on Mon, 23 May 2011 18:16
		Re: problem saving date fields By: Co on Mon, 23 May 2011 19:17
		Re: problem saving date fields By: Jerry Stuckle on Mon, 23 May 2011 22:00
		Re: problem saving date fields By: Co on Tue, 24 May 2011 05:30
		Re: problem saving date fields By: Jerry Stuckle on Tue, 24 May 2011 09:45
		Re: problem saving date fields By: Co on Thu, 26 May 2011 09:10
		Re: problem saving date fields By: Jerry Stuckle on Thu, 26 May 2011 09:43
		Re: problem saving date fields By: Co on Mon, 23 May 2011 21:26
		Re: problem saving date fields By: Jerry Stuckle on Mon, 23 May 2011 22:01
		Re: problem saving date fields By: Thomas 'PointedEars' on Mon, 23 May 2011 21:59
		Re: problem saving date fields By: Twayne on Sun, 22 May 2011 13:11

Previous Topic:	is dis da place?
Next Topic:	foreach in reverse

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 18:51:26 GMT 2024

Total time taken to generate the page: 0.04296 seconds