[Resolved] Odd search results...

[influx]

I am about to release a simple search feature on my website for people to either search through the database of names or usernames. Here is what the search query looks like in PHP:

$query="SELECT * FROM users WHERE name OR username LIKE '%$name%' LIMIT 0, 100";

Now, everything seems to work just fine except for the fact that every single time i make a search query, whether it be 'a' or 'aoisdf098a7sd0f98a7sdf', it always returns the following result:

username: 4carmaperk
name: 4th grade information

This user is the only user in the database whose username begins with a number...is that why he always appears? How can I fix this?

Thanks!
-influx

[BuzzLY]

try:

$query="
   SELECT * FROM users 
      WHERE name LIKE '%$name%' 
      OR username LIKE '%$name%' 
      LIMIT 0, 100";

[influx]

that does it! thanks.