i have a form with a text field for $search
the script runs selecting from a field in the db containing %$search%
the problem is this only allows for single word searches, unless the search words are typed in the smae order as they appear in the field. so i need to replace spaces with "%" so if people search for say "this search phrase" the $search variable becomes "this%search%phrase"
how do i do this, or is there a better way?
the script runs selecting from a field in the db containing %$search%
the problem is this only allows for single word searches, unless the search words are typed in the smae order as they appear in the field. so i need to replace spaces with "%" so if people search for say "this search phrase" the $search variable becomes "this%search%phrase"
how do i do this, or is there a better way?