strip spaces

Use the trim() function.
http://us2.php.net/manual/en/function.trim.php

Hi Rgb,

You are search the value of  "Order id". I think order is number datatype.. no need add ' ' of your query...

Refer the below query...its helpful for you

  $this->sql = "Select * FROM orders WHERE orderid like %$this->text%";

thanks

The accepted solution works okay unless you search on multiple words (a phrase).

For multiple words -- you need spaces between them, which is why I still believe trim function is the better solution.

        $inputdata = trim($this->text);

        $this->sql = "FROM orders WHERE orderid like '%$inputdata%'";
        break;