Re: [PHP-DB] Simple search engine gone bad
Hi Jennifer, if($searchword = $iname) try it with a double equals sign if($searchword == $iname) { echo TABLE BORDER='0' WIDTH='95%' CELLPADDING='0' CELLSPACING='0'TR; echo TD width=20%a href='usershop.php?user=$user'$user/a/TD; echo TD width=40%font size=2$iname/font/TD; echo TD width=20%font size=2CENTER$q/CENTER/font/TD; echo TD width=30%font size=2CENTER$price/CENTER/font/TD; echo /TD/TR/TABLE; } } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Simple search engine gone bad
Hi all, It's Monday, it's probably something stupid, but I have poured over this all day and cannot find the problem. This is a simple search engine based on one table. It is suppose to return the results of the search word. Instead it returns ALL records in the mysql table. If I type the letter x and there are no words in the table with an x I still get all records returned. Would someone be kind enough to show me what I have done wrong. if($search) { $query = SELECT iname, quantity, user, price FROM {$config[prefix]}_shop WHERE iname LIKE '%$searchword%' AND price 0 ORDER BY price; $ret = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($ret)) { $user = $row['user']; $iname = $row['iname']; $q = $row['quantity']; $price = $row['price']; if($searchword = $iname) { echo TABLE BORDER='0' WIDTH='95%' CELLPADDING='0' CELLSPACING='0'TR; echo TD width=20%a href='usershop.php?user=$user'$user/a/TD; echo TD width=40%font size=2$iname/font/TD; echo TD width=20%font size=2CENTER$q/CENTER/font/TD; echo TD width=30%font size=2CENTER$price/CENTER/font/TD; echo /TD/TR/TABLE; } } }else{ echo FORM METHOD=post ACTION='$PHP_SELF'; echo Search ShopsBRinput type=text name=\searchword\ value=\\; echo BRINPUT TYPE='submit' NAME='search' VALUE='Search'; } Thank you 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
Re: [PHP-DB] Simple search engine gone bad
if($search) { $query = SELECT iname, quantity, user, price FROM {$config[prefix]}_shop WHERE iname LIKE '%$searchword%' AND price 0 Try putting $searchword within single quotes. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Simple search engine gone bad
Jenn, Get rid of 'value=\\' in your code and give it a shot again... Gurhan -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 9:32 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Simple search engine gone bad Hi all, It's Monday, it's probably something stupid, but I have poured over this all day and cannot find the problem. This is a simple search engine based on one table. It is suppose to return the results of the search word. Instead it returns ALL records in the mysql table. If I type the letter x and there are no words in the table with an x I still get all records returned. Would someone be kind enough to show me what I have done wrong. if($search) { $query = SELECT iname, quantity, user, price FROM {$config[prefix]}_shop WHERE iname LIKE '%$searchword%' AND price 0 ORDER BY price; $ret = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($ret)) { $user = $row['user']; $iname = $row['iname']; $q = $row['quantity']; $price = $row['price']; if($searchword = $iname) { echo TABLE BORDER='0' WIDTH='95%' CELLPADDING='0' CELLSPACING='0'TR; echo TD width=20%a href='usershop.php?user=$user'$user/a/TD; echo TD width=40%font size=2$iname/font/TD; echo TD width=20%font size=2CENTER$q/CENTER/font/TD; echo TD width=30%font size=2CENTER$price/CENTER/font/TD; echo /TD/TR/TABLE; } } }else{ echo FORM METHOD=post ACTION='$PHP_SELF'; echo Search ShopsBRinput type=text name=\searchword\ value=\\; echo BRINPUT TYPE='submit' NAME='search' VALUE='Search'; } Thank you 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