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 #174099 is a reply to message #174079]

Sat, 21 May 2011 14:32

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 5/20/2011 11:13 PM, Jeff North wrote:

<Several pieces of unrelated items snipped>

> On Fri, 20 May 2011 22:35:03 -0400, in comp.lang.php Jerry Stuckle
> <jstucklex(at)attglobal(dot)net>
> <ir78cp$53s$1(at)dont-email(dot)me> wrote:
>
>> |>
>> |> How are you setting the $arrival_* and $depature_* values?
>> |
>> | From the input - after is is sent from his form.
>
> Therefore the variables aren't initialised and would cause php errors
> - right?
>

Not if he's programmed correctly and is not using them. There is no
need to initialize variables which are not being used.

>> |> If this is a new entry then all of the $arrival_* and $depature_* will
>> |> be null or zero - therefore the select options will not be
>> |> automatically selected (View Source of the page to see if there are
>> |> any error messages within these lists).
>> |
>> | No, because he isn't setting them until after the form has been
>> | displayed and the user has made his selection.
>
> Methinks you are making too many assumptions - have you seen the full
> source code of the page?
>

No, but I've seen enough to understand what he's doing.

>
> Who said anything about "add a row every time the page is displayed".
> According to your criteria there would never be any edit pages - only
> add pages.
>
> If editing an existing item wouldn't you want to read the already
> stored data from the database?
>

That's what it looked like you were trying to say.

> i.e.
> // initialise variables to meaningful values
> // if editing an existing entry
> // read record
> // overwrite initialised variables
> // display the page
>

Completely unnecessary to initialize values which are not used.

>> |
>> | He needs to do other validation on the data also, but first he needs to
>> | get this part working.
>
> ...and how do you know this, hmmmm?
>

Because I see the code he's using.

>> |>> | $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.
>> |>
>> |> But are the values your setting the ones you expect?
>> |
>> | That's why the suggestion to print the SQL statement he generated.
>
> The SQL statement should be ok - it's the "When I change of them the
> other one gets set back to default: 00-00-0000" I'm considering.
>

The SQL statement is NOT ok. As he would find if he printed it out as
was suggested.

>> | BTW - your sig separator is broken. It needs to be exactly
>> | hyphen-hyphen-space-newline.
>
> Oh Jerry is now the sig line cop :-P
> Complain to the writers of Thunderbird as I couldn't care less about
> whether or not my sig appears 'correctly' in your news reader.
> -- -------------------------------------------------
> The supplied code is for guideline purposes only.

It has nothing to do with Thunderbird. It has EVERYTHING to do with
following usenet standards, in this case RFC 3736.

But I see you're as clueless about rfcs as you are programming.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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:34:30 GMT 2024

Total time taken to generate the page: 0.06412 seconds