Re: Update

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" <milesthompson@ns.sympatico.ca> wrote in message news:5.0.2.1.0.20020204191455.01624c98@pop1.ns.sympatico.ca... 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