- Posts: 8
- Thank you received: 0
bonjour
Je souhaiterais savoir quelle valeur est remonté via la commande where id=@user_id ??? L'id de la table users de Joomla ou le username ???
Merci
Please Log in or Create an account to join the conversation.
Bonjour. My French is not good.
I understood your question as:
I would like to know what value is recovered via the command where id = @ user_id?? The id of the users of Joomla or username? Table?
Based on my experience as a user, the 'id' would be your database field name and the 'user_id' is the numeric number of the Joomla user.
So I use for example where userid = @user_id and by that the userid is a field in my DB which has user numbers in it. This then will show the ones relating to the current logged in user.
Please Log in or Create an account to join the conversation.
Thanck's I try.
Please Log in or Create an account to join the conversation.
Ok i cant.
I make a grid on this table (french in text) jos_contrats, database name is bpo. and in jos_contrat i have 'id' same of 'id' in my table bpo.jnew_users.
for you wath is the syntax for the user sees only his data.
Sorry for my English if you prefer in french say that
Thank's
Please Log in or Create an account to join the conversation.
Hi,
This if you create a grid on table jos_contrats and your column id corresponds to the id of the joomla user the syntax would be:
id=@user_id
Please Log in or Create an account to join the conversation.
Yes is work !!!!
Thank's
Please Log in or Create an account to join the conversation.