Dear Ethan
It seems you are trying to build a query.But you are not getting field
names. If you required field names then change the following line to
foreach ( $allowed_fields AS $field => $_POST['field'])
to
foreach ( $allowed_fields AS $field)
This would convert the variable field to value. In yoyr line the variable
field is treated as array index
============
regds
amit
"The difference between fiction and reality? Fiction has to make sense."
On Fri, Feb 10, 2012 at 9:40 AM, Ethan Rosenberg <ethros@xxxxxxxxxxxxx>wrote:
> 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
>
>
