Problem w/query - again

[Ethan Rosenberg <ethros@xxxxxxxxxxxxx>]

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