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

Reply via email to