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

Sat, 21 May 2011 07:57

Luuk
Messages: 329
Registered: September 2010

Karma:

Senior Member

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

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: Fri Sep 20 12:27:03 GMT 2024

Total time taken to generate the page: 0.05230 seconds