Member Avatar for iammirko

Hi I am using the following query:

"SELECT * FROM members WHERE name LIKE '$searchKey%';"

Where $searchKey is a variable that contains the string to be searched. The problem is that the code only searches until it has found a space and even if characters after space match the value, it returns null.

Eg:
Database has two entries:
Andy Johnson
Paul Ford

1. $searchKey = "An" - The code works fine and returns 'Andy Johnson'
2. $searchKey = "For" - Returns Null; however I want it to return "Paul Ford"

Thanks

Edited by iammirko because: Incomplete written
  • 2 Contributors
  • 2 Replies
  • 99 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by iammirko
Member Avatar for hielo

put a % symbol BEFORE and AFTER the variable name:

"SELECT * FROM members WHERE name LIKE '%$searchKey%';"
Member Avatar for iammirko

It works!

Thanks a lot!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.