Query is not working

[RemiAdem45]

Hello

Here is my request:

Code: Select all

$query = $bdd->getQuery(true);
$cond="a.clef= PASSWORD('".$_POST['form']['identifiant']."')";
$query
    ->select(array('a.ref', 'b.Nom', 'b.Prenom','c.Email'))
    ->from($bdd->quoteName('#__XXXIDlecon', 'a'))
    ->join('INNER', $bdd->quoteName('#__XXXmembres', 'b') . ' ON ' . $bdd->quoteName('a.ref') . ' = ' . bdd->quoteName('b.Ref'))
    ->join('INNER', $bdd->quoteName('#__XXXcontacts', 'c') . ' ON ' . $bdd->quoteName('a.ref') . ' = ' . $bdd->quoteName('c.Membre'))
    ->where($cond);
$bdd->setQuery($query);
$result = $bdd->loadAssoc();

And the result is an empty array

But if I go to my data base with phpmyadmin and I run this request I have a result
here is the equivalent of the request in sql

Code: Select all

SELECT a.ref, b.Nom,b.Prenom,c.Email from yyy000_XXXIDlecon as a
INNER join yyy000_XXXmembres AS b ON a.ref = b.Ref
INNER join yyy000_XXXcontacts as c ON a.ref = c.Membre
WHERE a.clef= PASSWORD('mdp');

Is there any way to see what is exactly in $query too see why this request is not working

[pe7er]

Is there any way to see what is exactly in $query too see why this request is not working

Yes, add the following line:

Code: Select all

echo $query->dump();

[RemiAdem45]

I manage to see what is in my query with your function and the query seems to be correct.
Just to be sure I tried an other one without jointure

Code: Select all

$query = $bdd->getQuery(true);
$query
    ->select(array('b.Nom', 'b.Prenom'))
    ->from($bdd->quoteName('#__XXXmembres', 'b')
    ->where($cond);
$bdd->setQuery($query);
$result = $bdd->loadAssoc();

the result is still empty but if I use $bdd->loadObject() instead of $bdd->loadAssoc();
I have the result