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
