prova cosi:
SELECT COUNT(tags.id_tags) as numRisorse,tags.id_tags,tags.nome,tags2risorse.id_ risorse FROM tags,tags2risorse WHERE tags.id_tags = tags2risorse.id_tags AND LOWER(nome) LIKE LOWER('$item%') GROUP BY tags.nome ORDER BY tags.nome
prova cosi:
SELECT COUNT(tags.id_tags) as numRisorse,tags.id_tags,tags.nome,tags2risorse.id_ risorse FROM tags,tags2risorse WHERE tags.id_tags = tags2risorse.id_tags AND LOWER(nome) LIKE LOWER('$item%') GROUP BY tags.nome ORDER BY tags.nome