This is the select I'm doing:
$query = "SELECT gestiondoc_publicados_tags.tag FROM gestiondoc_publicados_tags, gestionDoc_publicados_permisos WHERE gestionDoc_publicados_permisos.id_publicado = gestiondoc_publicados_tags.id_publicado AND gestionDoc_publicados_permisos.cargo = :cargo";
The table gestiondoc_publicados_tags is like:
| id | tag | id_publicado |
| 1 | tag1| 1 |
| 2 | tag2| 1 |
The table gestiondoc_publicados_permisos is like:
| id | cargo | id_publicado |
| 1 | cargo1 | 1 |
| 2 | cargo2 | 1 |
I want to get every tag where the id_publicado is equal to the id_publicado where cargo is equal to cargo1, but I'm only getting tag1 as the result, how can I do the query properly?
Aucun commentaire:
Enregistrer un commentaire