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" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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 <[EMAIL PROTECTED]> 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" <[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
