Database Problems

Dear List -

I have a database:

+---------------------+
| Tables_in_hospital2 |
+---------------------+
| Intake3             |
| Visit3              |
+---------------------+

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    |       |
+--------+-------------+------+-----+---------+-------+

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    |                |
+--------+--------------+------+-----+---------+----------------+

mysql> mysql> select * from Intake3  where  1  AND (Site  = 
'AA')  AND (Sex  = 'Male') ;
+------+--------+---------+-----------+--------------+--------+------+-----------------------------------------------------------------------+
| Site | MedRec | Fname   | Lname     | Phone        | Height | 
Sex  | Hx                                                                    |
+------+--------+---------+-----------+--------------+--------+------+-----------------------------------------------------------------------+
| AA   |  10003 | Stupid  | Fool      | 325 563-4178 |     65 | Male 
| Has been convinced by his friends that he is obese. Normal
BMI = 23. |
| AA   |  10000 | David   | Dummy     | 845 365-1456 |     66 | Male 
| c/o obesity. Various treatments w/o success                           |
| AA   |  10001 | Tom     | Smith     | 984 234-4586 |     68 | Male 
| BMI =  20.  Thinks he is obese.                                       |
| AA   |  10007 | Foolish | Fool      | 456 147-321  |     60 | Male 
| Thinks he is thin. BMI = 45                                           |
| AA   |  10005 | Tom     | Obstinant | 845 368-2244 |     66 | Male 
| Insists that he is not fat.  Becomes violent.  Psych involved.        |
| AA   |  10015 | Dim     | Wit       | 321 659-3111 |     70 | Male 
| Very Tall                                                             |
| AA   |  10040 | Bongish | Bongish   | 123 456-7890 |     50 | Male 
| Bong                                                                  |
+------+--------+---------+-----------+--------------+--------+------+--------------------------------------------------------------------- 




The same query in a PHP program will only give me results for MedRec 10003

        $allowed_fields = array
             (  'Site' =>$_POST['Site'], 'MedRec' => 
$_POST['MedRec'], 'Fname' => $_POST['Fname'], 'Lname' => $_POST['Lname'] ,
              'Phone' => $_POST['Phone'] , 'Sex' => $_POST['Sex']  , 
'Height' => $_POST['Height']  );
        if(empty($allowed_fields))
        {
             echo "ouch";
        }


     $query = "select * from Intake3  where  1 ";

     foreach ( $allowed_fields as $key => $val )
     {

         if ( (($val != '')) )

         {
                 $query .= " AND ($key  = '$val') ";
         }

     $result1 = mysqli_query($cxn, $query);

     }

Ethan

MySQL 5.1  PHP 5.3.3-6  Linux [Debian (sid)] 



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