- #1
klusener
- 62
- 0
Hi everyone,
I'm just beginning to learn php, but I'm working on a small script where I'm trying to search a few fields in a table and if the values match, other fields in the same row are displayed.
The db has just one table with 6 fields: ID (primary key), words, definitions, roots, prefixes, and suffixes.
I'm trying to make the search engine get the value from a search form, check it against roots, prefixes, and suffixes. If any of them equal the value, the values from words, and definitions need to be displayed.
But, for some reason it just doesn't work when I arrange the code like this:
$query = "SELECT words, definitions FROM Etym WHERE roots = '$trimm' OR prefixes = '$trimm' OR suffixes = '$trimm'";
I'm attaching both the search.php and the search form, if any of you would like to help me out of this mess. I would really appreciate any advice.
Thanks.
I'm just beginning to learn php, but I'm working on a small script where I'm trying to search a few fields in a table and if the values match, other fields in the same row are displayed.
The db has just one table with 6 fields: ID (primary key), words, definitions, roots, prefixes, and suffixes.
I'm trying to make the search engine get the value from a search form, check it against roots, prefixes, and suffixes. If any of them equal the value, the values from words, and definitions need to be displayed.
But, for some reason it just doesn't work when I arrange the code like this:
$query = "SELECT words, definitions FROM Etym WHERE roots = '$trimm' OR prefixes = '$trimm' OR suffixes = '$trimm'";
I'm attaching both the search.php and the search form, if any of you would like to help me out of this mess. I would really appreciate any advice.
Thanks.