RE: [PHP-DB] moving though an array..SOLVED
> -Original Message-
> From: Aaron Wolski [mailto:[EMAIL PROTECTED]
> Sent: 26 June 2003 16:12
>
> Solved my problem!
>
> Here's the code in case anyone really cares :P
>
> $col = explode(",",$threadsColumn);
>
> $col_search = "(";
> for ($i=0;$i
> $col_search .= $col[$i]." LIKE
> '%$threadsName%'";
> if ($i != (count($col) - 1)) {
> $col_search .= " OR ";
>}
> }
>
> $col_search .= ")";
Yes, that's about how I'd do it -- you may, however, be interested in this variation
on the theme:
$col = explode(",",$threadsColumn);
$col_search = array();
foreach ($col as $col_name) {
$col_search[] = "$col_name LIKE '%$threadsName%'";
$col_search = "(" . implode(' OR ', $col_search) . ")";
A completely different approach might be to do it like this:
$col_search = "("
. str_replace(',',
" LIKE '%$threadsName%' OR ",
$threadsColumn)
. " LIKE '%$threadsName%'"
. ")";
Cheers!
Mike
-
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] moving though an array..SOLVED
Hi All,
Solved my problem!
Here's the code in case anyone really cares :P
$col = explode(",",$threadsColumn);
$col_search = "(";
for ($i=0;$imailto:[EMAIL PROTECTED]
Sent: June 26, 2003 10:26 AM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] moving though an array..
One Thing:
Change $columns[] to $colums, example:
$columns = explode(',',$threadsColumn);
On Thu, 2003-06-26 at 10:23, Aaron Wolski wrote:
> 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
> $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
>
--
Adam Voigt ([EMAIL PROTECTED])
Linux/Unix Network Administrator
The Cryptocomm Group
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] moving though an array..
Hi Adam,
Thanks...typing errors can be a killer sometimes.
However, the cleared up the "Array" display error but not the displaying
the contents what's in the $columns array.
Thanks for your help!
Aaron
-Original Message-
From: Adam Voigt [mailto:[EMAIL PROTECTED]
Sent: June 26, 2003 10:26 AM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] moving though an array..
One Thing:
Change $columns[] to $colums, example:
$columns = explode(',',$threadsColumn);
On Thu, 2003-06-26 at 10:23, Aaron Wolski wrote:
> 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
> $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
>
--
Adam Voigt ([EMAIL PROTECTED])
Linux/Unix Network Administrator
The Cryptocomm Group
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] moving though an array..
One Thing:
Change $columns[] to $colums, example:
$columns = explode(',',$threadsColumn);
On Thu, 2003-06-26 at 10:23, Aaron Wolski wrote:
> 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
> $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
>
--
Adam Voigt ([EMAIL PROTECTED])
Linux/Unix Network Administrator
The Cryptocomm Group
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
