}
}
- $response = $dbh->prepare('SELECT *, p.active, p.validate FROM pub_Bookmark LEFT JOIN pub_Project p ON (pub_Bookmark.projectId = p.id)
- WHERE userId = :pseudo
+ $response = $dbh->prepare('SELECT pub_Bookmark.*, pub_Project.active, pub_Project.validate FROM pub_Bookmark, pub_Project
+ WHERE userId = :pseudo AND pub_Bookmark.projectId = pub_Project.id
');
$response->execute(['pseudo' => $this->element]);
}
// Vue que j'affiche qu'une fiche projet
- $response = $dbh->prepare('SELECT * FROM pub_Funding LEFT JOIN pub_Project p ON (pub_Funding.projectId = p.id)
- WHERE userId = :pseudo group by projectId
+ $response = $dbh->prepare('SELECT pub_Funding.*, pub_Project.active, pub_Project.validate FROM pub_Funding, pub_Project
+ WHERE userId = :pseudo AND pub_Funding.projectId = pub_Project.id
');
$response->execute(['pseudo' => $this->element]);