moving though an array..
| From: | Aaron Wolski | Date: | Thu, 26 Jun 2003 14:23:55 +0000 |
| Subject: | moving though an array.. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28904@lists.php.net to get a copy of this message | ||
Hi All,
Hopefully someone here can point me in the right direction.
I need to create a SELECT statement based on some criteria select and
entered into a form.
Form variables:
$threadsColumn = "manufactuer,colour";
$string = "n";
Code:
$columns[] = explode(",",$threadsColumn);
$test = "(";
for ($i=0;$i<sizeof($columns);$i++) {
$test .= $columns[$i]." %$string%";
}
$test .= ")";
echo $test;
What I am attempting to do is create a select statement that would look
like (based on "form variables"):
SELECT * FROM tablename WHERE (manufacturer LIKE %n% OR colour LIKE %n%)
The information between ( and ) needs to be written in such a manner
that it scales up or down in options.. depending on what was selected in
the form.
ANYONE have some thoughts?
Oh.. when I echo the above code I get this: (Array %h%)
Thanks!
Aaron