Hi!
I got a problem. I want to find all the records in a table where an post var is located in a filed(whether it exists in any part of it).It is for a search engine.
I tried the following SQL Query but not working:
select * from scripts where locate(lower($msg),lower(description)) limit $part,30
It is directly copied from the PHP Source of my Search.php3 file.
TIA,
regards
Boyan Djumakov
I got a problem. I want to find all the records in a table where an post var is located in a filed(whether it exists in any part of it).It is for a search engine.
I tried the following SQL Query but not working:
select * from scripts where locate(lower($msg),lower(description)) limit $part,30
It is directly copied from the PHP Source of my Search.php3 file.
TIA,
regards
Boyan Djumakov