Re: FN-FORUM: MySQL PHP Query

date posted 21st January 2007 15:31

> if I have an array the query
>
> FROM tbl_value_info as pi
> WHERE value=3D "'.$value.'"';
>
> wont work because I need AND or is there a way around this?

You need a query like:

FROM tbl_value_indo as pi WHERE value IN (1,2,3)

For this, the implode() function is useful:

$values =3D array(1,2,3);
$values_sql =3D implode(',',$values);
$sql =3D "SELECT * FROM tbl_value_indo AS pi WHERE value IN ($values_sql=
)";

Cheers!

Anthony
-- =

www.fonant.com - Quality web sites