Jump to content

Recommended Posts

Bonsoir, le formulaire de contact me propose les contacts de toutes mes boutiques, et ce peu importe sur laquelle je me trouve.

 

La faute à une jointure ?

 

Voici ce que me donne en clair la requête exécutée dans la classe Contact, fonction getContacts($id_lang) :

 

 

SELECT * FROM `hellov3_contact` c LEFT JOIN hellov3_contact_shop contact_shop ON contact_shop.id_contact = c.id_contact AND contact_shop.id_shop IN(1) LEFT JOIN `hellov3_contact_lang` cl ON (c.`id_contact` = cl.`id_contact`) WHERE cl.`id_lang` = 4 ORDER BY `name` ASC

 

Je regarde comment corriger cela en *douceur*

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...