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 #174086 is a reply to message #174085]

Sat, 21 May 2011 08:34

Co
Messages: 75
Registered: May 2011

Karma:

Member

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

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: Tue Nov 26 10:43:49 GMT 2024

Total time taken to generate the page: 0.04209 seconds