Question

I m using the jquery autocomplete plugin for displaying a list of cities to the user. I m working with the Symfony 1.4 framework with Doctrine. I have a table with all the cities name.

When the user start entering a city name in the concerned input, i m doing this SQL query :

    $q = $this->createQuery( v )
     ->where( v.name like ? , $string. % )
     ->orderBy( v.name )
     ->limit($limit)
     ->execute();

如果是用户进入的铺面,则在纸面上设定限额。

In my table, there are several cities with the same name and I only see one of them in the results...

当我照搬了Sandreadmin的询问时,我看所有结果......

如果任何人都有一cl子,那将受到非常赞赏!

增编

Answer 1

check this:

$q = $this->createQuery( v )
 ->where( v.name like ? ,  % .$string. % )
 ->orderBy( v.name )
 ->limit($limit)
 ->execute();

友情链接