Recherche
Joueurs & Entraineurs
query('SELECT users.id_users, users.image, users.nom_users, users.prenom_users, type_users.img_type, type_users.nom_type, YEAR(CURRENT_TIMESTAMP) - YEAR(users.date_naissance) - (RIGHT(CURRENT_TIMESTAMP, 5) < RIGHT(users.date_naissance, 5)) as age FROM users INNER JOIN type_users ON users.categorie_users = type_users.sigle ORDER BY users.date_inscription DESC LIMIT 4');
while ($dataListeUsers = $listeUsers->fetch())
{
?>
prepare('SELECT users_prcs.poste_prcs, ligue.nom_ligue, poste.categorie_poste, categorie.nom_categorie, poste.img_poste, poste.nom_poste, users_prcs.id_users, users_prcs.club_prcs FROM users_prcs INNER JOIN poste ON users_prcs.poste_prcs = poste.sigle INNER JOIN categorie ON categorie.sigle = users_prcs.categorie_prcs INNER JOIN ligue ON users_prcs.ligue_prcs = ligue.sigle WHERE id_users = ? ORDER BY annee_fin_prcs DESC LIMIT 1');
$reqPrcs->execute(array($dataListeUsers['id_users']));
while ($dataPrcs = $reqPrcs->fetch())
{
?>
; ?>)
Club :
Opportunité
query('SELECT * FROM offre INNER JOIN type_users ON offre.type = type_users.sigle INNER JOIN poste ON offre.poste = poste.sigle INNER JOIN users ON offre.id_user = users.id_users INNER JOIN ligue ON offre.ligue = ligue.sigle INNER JOIN categorie ON offre.categorie = categorie.sigle INNER JOIN users_prcs ON offre.id_user = users_prcs.id_users WHERE club_actuel = "1" AND offre.id_user != "'.$_SESSION['id_user'].'"');
while ($dataListeOffre = $listeOffre->fetch())
{
?>
