el codigo de la parte "like" es:
con 2 like me funciona:
Código PHP:
"SELECT * FROM empreses WHERE (nomempresa_cat like '%%%s%%' or frase_cat like '%%%s%%') and
idpoble like '%s'
ORDER BY idempresa limit $inicio,$TAMANO_PAGINA", $colname_Recordset1,$colname_Recordset1,$colname2_Recordset1);
Pero no con 6:
Código PHP:
"SELECT * FROM empreses WHERE
(nomempresa_cat like '%%%s%%' or
nomempresa_esp like '%%%s%%' or
nomempresa_eng like '%%%s%%' or
frase_cat like '%%%s%%' or
frase_esp like '%%%s%%' or
frase_eng like '%%%s%%') and
idpoble like '%s'
ORDER BY idempresa limit $inicio,$TAMANO_PAGINA", $colname_Recordset1,$colname_Recordset1,$colname2_Recordset1);
me da el error: Query was empty