Problem w/query - again

From: Date: Fri, 10 Feb 2012 04:10:45 +0000
Subject: Problem w/query - again
Groups: php.db 
Request: Send a blank email to php-db+get-48196@lists.php.net to get a copy of this message
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

« previous php.db (#48196) next »