Re: 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<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 > -- Adam Voigt (adam@cryptocomm.com) Linux/Unix Network Administrator The Cryptocomm Group