Re: how to do query on partial field contents ???

Frank Flynn wrote:

And if you'd like to make wild carding optional keep your code the way it is:

    $query .= " AND model LIKE '".$_GET['search']."'";

And put a comment on the web page "Use the % for wild cards". The thing about:

      $query .= " AND model LIKE '%".$_GET['search']."%'";

Is it will return many results if $_GET['search'] is very small like one letter.

And bear in mind that there's could be a nasty SQL injection problem with that code if $_GET['search'] hasn't been SQL escaped in some way. -- Andy Armstrong, Tagish