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

problem saving date fields [message #174052]

Fri, 20 May 2011 18:38

Co
Messages: 75
Registered: May 2011

Karma:

Member

Hi All,

I have two date fields.
When I change of them the other one gets set back to default:
00-00-0000
I have to save both to make it work. Is there a solution for this?

The arrival_date and departure_date are build up like this:

<select name="arrival_day" class="formFields" id="arrival_day">
<option value="<?php print "$arrival_day"; ?>"><?php print
"$arrival_day"; ?></option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option> etc......

<select name="arrival_month" class="formFields" id="arrival_month">
<option value="<?php print "$arrival_month"; ?>"><?php print
"$arrival_month"; ?></option>
<option value="01">January</option>
<option value="02">February</option>
<option value="03">March</option>
<option value="04">April</option> etc......

<select name="arrival_year" class="formFields" id="arrival_year">
<option value="<?php print "$arrival_year"; ?>"><?php print
"$arrival_year"; ?></option>
<option value="2011">2013</option>
<option value="2011">2012</option>
<option value="2011">2011</option>
<option value="2010">2010</option> etc......

The table is updated like this:

$arrival_month = preg_replace('#[^0-9]#i', '',
$_POST['arrival_month']);
$arrival_day = preg_replace('#[^0-9]#i', '',
$_POST['arrival_day']); // filter everything but numbers
$arrival_year = preg_replace('#[^0-9]#i', '',
$_POST['arrival_year']); // filter everything but numbers
$arrival_date = "$arrival_year-$arrival_month-$arrival_day";

$departure_month = preg_replace('#[^0-9]#i', '',
$_POST['departure_month']);
$departure_day = preg_replace('#[^0-9]#i', '',
$_POST['departure_day']); // filter everything but numbers
$departure_year = preg_replace('#[^0-9]#i', '',
$_POST['departure_year']); //
$departure_date = "$departure_year-$departure_month-$departure_day";

$sqlUpdate = mysql_query("UPDATE myMembers SET
firstname='$firstname', lastname='$lastname', gender='$gender',
partner='$partner', country='$country', rank='$rank',
service='$service', position='$position',
arrival_date='$arrival_date',departure_date='$departure_date' WHERE
id='$id' LIMIT 1");

Is there a reason why this happens? I do create the right format to
put the data back in the table.

Regards
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: Sat Nov 23 01:47:02 GMT 2024

Total time taken to generate the page: 0.03924 seconds