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 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 > > > > > > -- > > > --- 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
