Re: Re: Search Script

Jennifer, Check if there is a "set exact" setting for MySQL. Using LIKE should find everything beginning with "Starr". You may also have to convert search term and target values to one of lower or upper case in the SELECT statement. Miles At 10:55 AM 4/25/2002 -0700, Jennifer Downey wrote:

I am quite positive that they are not Binary what I am finding is that it has to be exactly as it is in the table. I have one item called StarrRacing Guide if I put in starr or Starr it will return nothing I have to spell it exactly like it is in the db "StarrRacing Guide". here is a dump of the table maybe I have done something wrong there: uid int(10) NOT NULL default '0', id int(5) NOT NULL default '0', iname varchar(50) NOT NULL default '', image varchar(100) NOT NULL default '', quantity int(10) unsigned NOT NULL default '1', type varchar(20) NOT NULL default '', price int(6) NOT NULL default '0', user varchar(50) NOT NULL default '', I did move the while curly brace down to include the echo and that part is working great returning all records found. Thanks Jennifer "Maureen" <biorn@ebmstpa.com> wrote in message news:200204251733.LAA15466@www2.ebmstpa.com... The if/else/echo should all be within the while loop. The way it is now, it should only show the last record returned, because that is the last value within the while loop. The way you have it, the rest would be done after it had looped through all of the records and it would return whatever the last values were for the $row array. According to the following link from the MySQL Manual at http://www.mysql.com/doc/S/t/String_comparison_functions.html, string comparisons using LIKE should be case insensitive as stated below:

     The following two statements illustrate that string comparisons are

case insensitive unless one of the operands is a binary string:

     mysql> SELECT 'abc' LIKE 'ABC';
         -> 1
     mysql> SELECT 'abc' LIKE BINARY 'ABC';
         -> 0

I am not sure why it is showing case sensitivity, unless as it states, one of the operands is a binary string. HTH Maureen Jennifer Downey <jendowney@attbi.com> said:

Thanks all, You people are awesome. I have it working but I still have 2 bugs First it is only showing the first record it finds with the search term,

not

all records associated with it. Second it has to be spelled exactly right or I get 0 results. in other words if Jelly is spelled Jelly and I type jelly I get nothing

but

if I spell it Jelly it will return only the first record it finds what

have

I done wrong? if($search) {

    $query = "SELECT uid, id, image, iname, quantity, user, type, price

FROM

{$config["prefix"]}_shop WHERE iname LIKE '%$searchword%' ORDER BY

iname";

$ret = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($ret)) { $user = $row['user']; $uiid = $row['uid']; $iid = $row['id']; $image = $row['image']; $iname = $row['iname']; $q = $row['quantity']; $type = $row['type']; $price = $row['price']; } if($searchword == $iname) { echo "<TABLE BORDER='0' WIDTH='95%' CELLPADDING='0' CELLSPACING='0'><TR>"; echo "<TD width=20%><a

href='remove.php?id=$id&remove=yes'>$user</a></TD>";

echo "<TD width=40%><font size=2>$iname</font></TD>"; echo "<TD width=20%><font size=2><CENTER>$q</CENTER></font></TD>"; echo "<TD width=30%><font size=2><CENTER>$price</CENTER></font></TD>"; echo "</TD></TR></TABLE>"; } }else{ echo "<FORM METHOD=post ACTION='$PHP_SELF'>"; echo "Search Shops<BR><input type=text name=\"searchword\" value=\"\">"; echo "<BR><INPUT TYPE='submit' NAME='search' VALUE='Search'>"; } Thanks Jennifer "Jennifer Downey" <jendowney@attbi.com> wrote in message news:20020425141620.75561.qmail@pb1.pair.com...

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