Thanks Maureen,
The == was the problem. I can search with upper and lower case and only
partial words.
Hosting is using 3.23.45 mysql so I don't believe that was the case.
Thanks again!
Jennifer
"Maureen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Here
Here is some more information I found in the manual about case sensitivity in
searches. The whole page is at
http://www.mysql.com/doc/C/a/Case_sensitivity.html
Here is the text that shows what might be the problem:
"In older MySQL versions LIKE comparisons where done on the uppercase value
o
Ok I am looking at the code an I'm thinking it has to be in the code because
I tried it on my box at home and it did the same thing.
So while looking hard at the code I came up with this:
if($searchword == $iname) this is the problem
if $searchword == $iname then it will echo everything I want i
Jennifer
I suggest you check out MySQLs full text indexing capabilities. If you
create a fulltext index on the text fields you want to search you can use
the MATCH function. This will perform a fuzzy matching search that returns
results in order of relevance. For details see
http://www.mysql.com/
Jennifer,
Check if there is a "set exact" setting for MySQL.
Using LIKE should find everything beginning with "Starr". You may also have
to convert search term and target values to one of lower or upper case in
the SELECT statement.
Miles
At 10:55 AM 4/25/2002 -0700, Jennifer Downey wrote:
>
Hello,
Jennifer Downey wrote:
> Hi all,
>
> I have been trying to build a search script for my site that deals with only
> one table in my db.
> As Julie Meloni pointed out look in the MySQL manual for LIKE clauses I
> can't seem to locate that clause in ether
> manual.
> Dan Brunner gave me thi
I am quite positive that they are not Binary what I am finding is that it
has to be exactly as it is in the table.
I have one item called StarrRacing Guide if I put in starr or Starr it will
return nothing I have to spell it exactly like it is in the db "StarrRacing
Guide".
here is a dump of the t
The if/else/echo should all be within the while loop. The way it is now, it
should only show the last record returned, because that is the last value
within the while loop. The way you have it, the rest would be done after it
had looped through all of the records and it would return whatever
Thanks all,
You people are awesome. I have it working but I still have 2 bugs
First it is only showing the first record it finds with the search term, not
all records associated with it.
Second it has to be spelled exactly right or I get 0 results.
in other words if Jelly is spelled Jelly and I
