Re: [PHP-DB] Simple search engine gone bad

2002-04-30 Thread Lisi 

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

Re: [PHP-DB] Simple search engine gone bad

2002-04-29 Thread CK Raju 


 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

2002-04-29 Thread Gurhan Ozen 

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