1
Good,
I’m having a problem with a search I did where the user filter content by district and county, is working well when I choose district and county without accents but when I choose a district and a county that contains accents does not return me any values I would like to know how I can resolve situation ?
PHP
$result_categoria = mysql_query("select * from categorias_estabelecimentos where categoria_slug='".$categoria."'");
while($row_categoria = mysql_fetch_object($result_categoria)){
$result_local=mysql_query("select * from estabelecimentos where id='".$row_categoria->estabelecimento_id."' and distritos='".$distritos."' and concelhos='".$concelhos."' and activo=1");
while($row_local=mysql_fetch_object($result_local)){
if(mysql_num_rows($result_local)>0){
$result_anexo_local=mysql_query("select * from estabelecimentos_anexos where id_mae='".$row_local->id."' and seccao='thumbnail'");
$row_anexo_local=mysql_fetch_object($result_anexo_local);
http://answall.com/questions/51165/problema-ao-comparar-string-com-acentos-mysql ??
– bfavaretto
Yes and that the problem even reminded me that I had already put this post but anyway I could not solve the suggestions that put there
– César Sousa
But it is not the case to reset. If the question remains the same, you can edit the other, and it reappears on the first page of the site. I’ll close this as duplicate ok?
– bfavaretto
Of course yes you are absolutely right I no longer remember that I had already put on the case yes can delete. thanks
– César Sousa
I edited the other question and did not come to first on the page
– César Sousa
It’s not instant, but it’s there now.
– bfavaretto