Problem w/query - again

Dear list -

This did not seem to post, so I am sending it again.

If it did post, and I missed it, my apologies.

Ethan
============
Dear list -

I have the following code:

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

$allowed_fields = array('Site', 'MedRec', 'Fname', 'Lname',
                         'Phone', 'Sex', 'Height');

foreach ( $allowed_fields AS $field => $_POST['field'])
{
         if ( ! empty( $_POST['field'] ) )
         {
                 $query .= " AND '$field' = '$_POST[$field]' ";
                 echo $query;
         }
}

This is the value of $_POST:


  Array
(
     [Site] => AA
     [MedRec] => 10000
     [Fname] =>
     [Lname] =>
     [Phone] =>
     [Height] =>
     [welcome_already_seen] => already_seen
)

I receive the following errors on run:



  Notice: Undefined offset: 0 in /var/www/srchrhsptl4.php on line 135
select * from Intake3 where  1 AND '0' = ''
Notice: Undefined offset: 1 in /var/www/srchrhsptl4.php on line 135
select * from Intake3 where  1 AND '0' = ''  AND '1' = ''
Notice: Undefined offset: 2 in /var/www/srchrhsptl4.php on line 135
select * from Intake3 where  1 AND '0' = ''  AND '1' = ''  AND '2' = ''

Advice and help please.

Thanks.


Ethan





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