samedi 27 juin 2015

Relational Select with condition

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