Jennifer,

I appreciate and I'm glad that you're learning. What you were proposing is 
an easy trap to fall into. It's just that I've worked on systems where, for 
no apparent reason, the designer had decided to store the number of 
days/months someone had been a member / tenant / on-account customer, what 
have you. Or decided to store the number of days an invoice was overdue.

There's an old adage, that the best way to learn how to build boats is to 
repair them. Well, maybe how not to build boats. That's what working on 
those systems taught me, plus my own measure of mistakes.

With regard to "techie talk", have you looked at any of the tutorials on 
the web on how to work with PHP, and if you're not a programmer, some basic 
stuff on determining what you want from your program, what you need to get 
that result, and outlining the necessary processing steps. Once you start 
working with PHP, or any other scripting language, you're crossing over 
into programming land. Time spent with pencil and paper, figuring out these 
things, is amply repaid when you sit down to the keyboard.

Don't be disconcerted by the programming part of it. The web is a strange 
place, very unlike any other programming environment, with conditions which 
trip up people who have been programming for years.

Regards - Miles Thompson

PS  When updating a numerical field in MySQL, the general form of the 
statement is like this

update table_name set counter = counter + 1 where some_condition_is_met

some_condition_is_met being something like "where member_id = '$member_id'",
or "where daily_temp = $temp_today"
/mt

PPS You on the West Coast?


At 05:24 PM 2/4/2002 -0800, Jennifer Downey wrote:
>Why? Because I am learning. It seemed like the way to do it. I didn't know
>all those things could happen. There is NO documentation, manual or tutorial
>for that matter that gives clear, in English directions on how to do
>something. People just assume that everyone knows techie talk. So they
>explain in technical terms in which 98% of us don't understand. So we have
>to do things by trial and error and learn by our mistakes and pray that
>someone who does know can explain in a way that we can understand.
>
>Regards
>Jennifer Downey
>
>"Miles Thompson" <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> >
> > Why? There's absolutely no point -- record the date a person became a
> > member and calculate the number of days from that.
> >
> > In addition, what happens when you fail to run the update routine? Or
> > someone runs it twice? Or it half runs, then dies because the database has
> > gotten so large that the script times out? Who is going to keep track of
> > when it was run? What check value scheme will you have in place to make
> > certain none of this happens?
> >
> > What you are planning to do is bad practice. Please reconsider.
> >
> > Regards - Miles Thompson
> >
> >
> > At 01:51 PM 2/4/2002 -0800, Jennifer Downey wrote:
> > >Hi,
> > >
> > >I am having problems with this code. I want to update a members number of
> > >days they have been a member can anyone help?
> > >
> > >$query["days"]=("UPDATE users set days_member VALUES = ('days_member' +
> > >'1'));
> > >$result=mysql_query($query["days"]);
> > >
> > >Thanks in advance
> > >JD
> > >
> > >
> > >
> > >--
> > >PHP Database Mailing List (http://www.php.net/)
> > >To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to