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
[PHP-DB] moving though an array..
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