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 
of each character (E == e but E <> ). In newer MySQL versions LIKE works 
just like the other comparison operators." 


What version of MySQL are you running?  If you do not know, check to see if 
you can do a search for something in upper case that is in the database in 
lower case.  If this works, then it looks like the situation above.  I think 
previously, you were searching using all lower case for a word that was in 
the database with an upper case letter in it.

HTH

Maureen


Jennifer Downey <[EMAIL PROTECTED]> said:

> 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 it to.
> What I needed to do is have it where it isn't == to anything in otherwords a
> null value.
> 
> So if $searchword = $iname then it will work as it is suppose to.
> 
> Thanks everyone for your time, effort and help.
> Jennifer
> 
> 
> 
> "Jennifer Downey" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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 this to go on:
> >
> > $query = "SELECT uid, id, image, iname, quantity, type FROM
> > {$config["prefix"]}_shop WHERE  iname  LIKE = '%$shopsearch% ORDER BY
> > iname'";
> > $ret = mysql_query($query);
> > while(list($quantity)=mysql_fetch_row($ret))
> >
> > But I can't seem to get this to work. I have never worked with LIKE before
> > and would appreciate any help on this.
> >
> > Thanks Julie and Dan for your time and effort.
> >
> > Thanks all for your time and help
> > Jennifer
> >
> >
> > --
> > The sleeper has awaken
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
> >
> >
> 
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 



-- 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to