And Maureen is right! We just so *used* to seeing equal signs in SELECT
statements.
Smacking fist on head .... Miles Thompson
At 02:23 PM 4/25/2002 +0000, Maureen wrote:
>The query should read as below, without the = after the LIKE:
>
>$query = "SELECT uid, id, image, iname, quantity, type FROM
>{$config["prefix"]}_shop WHERE iname LIKE '%$shopsearch% ORDER BY
>iname'";
>
>HTH
>
>Maureen
>
>
>Jennifer Downey <[EMAIL PROTECTED]> said:
>
> > 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
> >
> >
> >
> > --
> > 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
