Re: Array Select from database
| From: | Robin Vickery | Date: | Wed, 28 Sep 2005 12:55:53 +0000 |
| Subject: | Re: Array Select from database | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-223351@lists.php.net to get a copy of this message | ||
On 9/28/05, Frank Keessen <fkeessen@gmail.com> wrote:
> O.K. Again;
> I have an array with one or more values, which must be selected in the
> database
> Array ( [count] => 1 [0] => Array ( [clientaccountmanager] => Array (
> [count] => 2 [0] => 210 [1] => 149 )
> Now i this is my select..
> I've got the following Query="select * from client WHERE
> clientaccountmanager='$value of array1' OR '$2nd value of array 1'"
>
> How can i loop through the query with all the values out of the array as OR
> value..
Are you trying to generate the query from the array?
If so, you are better off using the SQL 'IN' construct.
SELECT * FROM client WHERE clientaccountmanager IN (value1, value2, value3,...)
Then all you need to do is generate a comma separated list of values
from the array, which you can easily do with join().
$values = join(', ', $array);
Then insert it in your query:
$query = "SELECT * FROM client WHERE clientaccountmanager IN ($values)"
-robin