Problem w/query - again
| From: | Ethan Rosenberg | 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