Re: PHP & Database Problems

Dear Ethan,

It would be useful to see what code you are using.

The syntax is:

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value


The data that you are required to enter is for Intake3. I am assuming that
the only change is the History and/or Phone that you need to update since
the Site, MedRec, Fname, Lname, Height and Sex should remain the same.
Therefore I imagine the code should be something like


mysql_query("UPDATE  Intake3  SET History='Has been convinced by his
friends that he is obese. Normal BMI = 23', Phone='325 563-4178'
WHERE MedRec='10000' LIMIT 1");


Having said that I notice that you have two primary keys in Intake3. Not
aware that a table can carry two.

Terry

On 2 May 2012 19:53, Ethan Rosenberg <[email protected]> wrote:

>  have a database
>
> mysql> describe Intake3;
> +--------+-------------+------**+-----+---------+-------+
> | Field  | Type        | Null | Key | Default | Extra |
> +--------+-------------+------**+-----+---------+-------+
> | Site   | varchar(6)  | NO   | PRI |         |       |
> | MedRec | int(6)      | NO   | PRI | NULL    |       |
> | Fname  | varchar(15) | YES  |     | NULL    |       |
> | Lname  | varchar(30) | YES  |     | NULL    |       |
> | Phone  | varchar(30) | YES  |     | NULL    |       |
> | Height | int(4)      | YES  |     | NULL    |       |
> | Sex    | char(7)     | YES  |     | NULL    |       |
> | Hx     | text        | YES  |     | NULL    |       |
> +--------+-------------+------**+-----+---------+-------+
> 8 rows in set (0.00 sec)
>
> mysql> describe Visit3;
> +--------+--------------+-----**-+-----+---------+------------**----+
> | Field  | Type         | Null | Key | Default | Extra          |
> +--------+--------------+-----**-+-----+---------+------------**----+
> | Indx   | int(4)       | NO   | PRI | NULL    | auto_increment |
> | Site   | varchar(6)   | YES  |     | NULL    |                |
> | MedRec | int(6)       | YES  |     | NULL    |                |
> | Notes  | text         | YES  |     | NULL    |                |
> | Weight | int(4)       | YES  |     | NULL    |                |
> | BMI    | decimal(3,1) | YES  |     | NULL    |                |
> | Date   | date         | YES  |     | NULL    |                |
> +--------+--------------+-----**-+-----+---------+------------**----+
>
> and a program to enter and extract data.
>
> I can easily extract data from the database. However, if I try to enter
> data, it goes into the incorrect record.  Following are some screenshots.
>  The program is attached.  [pardon the comical names.  This is a test, and
> any resemblance to true names is not intentional....]
>
> Let us say that I wish to deal with Medical Record 10000:
>
>
> This it data from Intake3:
> Site Medical Record First Name Last Name Phone Height Sex History
> AA 10000 David Dummy 845 365-1456 66 Male c/o obesity. Various treatments
> w/o success
>
> This is data from Visit3:
> Index Site Medical Record Notes Weight BMI Date
> 2322 AA 10000 Second Visit. 170 27.4 2010-01-20
> 2326 AA 10000 Third visit. Small progress, but pt is very happy. 165 26.6
> 2010-02-01
>
>
> I then request to enter additional data:
>
> Site Medical Record First Name Last Name Phone Height Sex History
> AA 10003 Stupid Fool 325 563-4178 65 Male Has been convinced by his
> friends that he is obese. Normal BMI = 23.
> Index Site Medical Record Notes Weight BMI Date
>
> Notice that it is entered into record 10003
>
> The data is "First Try"
>
> Index Site Medical Record Notes Weight BMI Date
> 2590 AA 10003 First Try 189 31.4 02 May 2012
>
> Help and advice, please.
>
> Thanks.
>
> Ethan
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>



-- 
*Terry Ally*
Twitter.com/terryally
Facebook.com/terryally
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
To print or not to print this email is the environmentally-searching
question!
Which has the highest ecological cost? A sheet of paper or constantly
switching on your computer and connecting to the Internet to read your
email?