Re: [PHP] Array Select from database

On 9/28/05, Silvio Porcellana <[EMAIL PROTECTED]> wrote: > > In addiction, I would (SQL)escape the values joined: supposing you are > using MySQL, I'd do: > $values = join("', '", array_map('mysql_real_escape_string', $array)); I agree entirely; I was just trying to keep things simple for the OP.

RE: [PHP] Array Select from database

Silvio Porcellana on Wednesday, September 28, 2005 9:37 AM said: > In addiction, I would (SQL)escape the values joined: supposing you are > using MySQL, I'd do: > $values = join("', '", array_map('mysql_real_escape_string', $array)); Now that's a Freudian slip if I

Re: [PHP] Array Select from database

A.J. Brown wrote: > > [code] > $values = join(', ', $array); > $query = "SELECT * FROM client WHERE clientaccountmanager IN ('$values')" > [/code] > Actually this doesn't seem right, the join should be: $values = join("', '", $array); # notice the ' inside the " In addiction, I would (SQL)escape

Re: [PHP] Array Select from database

There is a small bug in your code: [snip] $values = join(', ', $array); $query = "SELECT * FROM client WHERE clientaccountmanager IN ($values)" [/snip] You'll need to surround "$values" with a single quote after joining: [code] $values = join(', ', $array); $query = "SELECT * FROM client WHERE c

Re: [PHP] Array Select from database

On 9/28/05, Frank Keessen <[EMAIL PROTECTED]> 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

Re: [PHP] Array Select from database

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 clientaccountm

RE: [PHP] Array Select from database

[snip] Hope you can help me out.. Array ( [count] => 1 [0] => Array ( [clientaccountmanager] => Array ( [count] => 2 [0] => 210 [1] => 149 ) I've got the following Query="select * from client WHERE clientaccountmanager='$value of array1' OR '$2nd value of array 1'" So that the query loops throug