Jump to content


Photo

Search Help


  • Please log in to reply
2 replies to this topic

#1 Skyotica

Skyotica
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 03 June 2006 - 01:49 AM

Hello, I am trying to fix the search for my site.

It is a search for users and item names in the database.

The problem is whenever a user submits "ITEM " instead of "ITEM", they recieve a "This item does not exist" message. I have seen many sites that allow users to submit either form of this. How would I be able to achieve this?

#2 legohead6

legohead6
  • Members
  • PipPipPip
  • Advanced Member
  • 434 posts

Posted 03 June 2006 - 04:48 AM

[!--quoteo(post=379512:date=Jun 2 2006, 08:49 PM:name=Skyotica)--][div class=\'quotetop\']QUOTE(Skyotica @ Jun 2 2006, 08:49 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Hello, I am trying to fix the search for my site.

It is a search for users and item names in the database.

The problem is whenever a user submits "ITEM " instead of "ITEM", they recieve a "This item does not exist" message. I have seen many sites that allow users to submit either form of this. How would I be able to achieve this?
[/quote]

whats the query your using? please show sum code
"Syntax error" .. WHERE THE **** IS IT?!

#3 Vikas Jayna

Vikas Jayna
  • Members
  • PipPipPip
  • Advanced Member
  • 121 posts
  • LocationNoida, Delhi, India

Posted 03 June 2006 - 08:46 AM

Use the trim function to remove the trailing spaces from the string being searched
Vikas Jayna,
Project Manager - Jeevansathi.com
7 yrs. exp. in LAMP
Certified Mysql DBA
Zend Certified Engineer




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users