Re: Argh ! array help required :(
| From: | Nenad Djordjevic | Date: | Thu, 06 Feb 2003 09:08:18 +0000 |
| Subject: | Re: Argh ! array help required :( | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25484@lists.php.net to get a copy of this message | ||
Hello Aaron,
* Try code like:
for ($i=0; $i<count($products); $i++) {
$products[$i] = "'".escapeValue($products[$i])."'";
}
$list_products = implode(',', $products);
if (strlen($list_products)) {
$prod_search = "in ($list_products)";
} else {
$prod_search = '';
}
* HTML form control need to be like:
<select name="products[]" size="5" multiple>
<option value="Product1">Product 1</option>
<option value="Product2">Product 2</option>
<option value="Product3">Product 3</option>
<option value="Product4">Product 4</option>
<option value="Product5">Product 5</option>
</select>
________________________
Best regards,
Nenad Djordjevic mailto:nenad@diyomisoft.com
Diyomi Soft
http://www.diyomisoft.com/
Wednesday, February 5, 2003, 6:13:27 PM, you wrote:
AW> Hi All,
AW> Again.. a little off topic - sorry (again!).
AW> Have a form that allows me to select a bunch of product names from a
AW> drop down combo box.
AW> I'm trying to create code like "in ('Product name1','Product Name2)
AW> to
AW> be inserted into an SQL statement.
AW> I figured that since $products was ALREADY in an array format the code
AW> below would work.. but it doesn't:
AW> $prod_search = "in(";
AW> for ($i=0;$i<count($products);$i++) {
AW> $prod_search .= escapeValue($products[$i]);
AW> if ($i != (count($products) - 1)) {
AW> $prod_search .= ",";
AW> }
AW> }
AW> $prod_search .= ")";
AW> Can anyone see where I am going wrong?
AW> Thanks!
AW> Aaron