Support Joomla!
  • Français
  • English
Ajout d'une condition dans la requete du module latest offers
Forums
Search:     Advanced search
4527 Posts in 1095 Topics by 31519 Members
Latest Member: nowresie
+  Forums
|-+  Produits - Français
| |-+  Extensions
| | |-+  NeoRecruit
| | | |-+  Ajout d'une condition dans la requete du module latest offers		 « previous next »
Pages: [1] Print
Author Topic: Ajout d'une condition dans la requete du module latest offers  (Read 407 times)
romain Chaillou
Newbie
*
Posts: 5


View Profile Email
« on: August 29, 2011, 03:26:39 PM »
Bonjour,
je cherche à ajouter une condition dans la requète des dernières offers du module latrestoffers, dans le fichier mod_neorecruit_latest_offers.php

Code:
// Offers
$query = "SELECT offers.* FROM #__neorecruit_offers AS offers "

. "\n WHERE offers.contact =".$truc

. "\n LEFT JOIN #__neorecruit_categories AS categories "
. "\n ON offers.category = categories.id "


J'ai déterminer un calcul du $truc, qui fonctionne (echo $truc me rends un chiffre).

Mais ma requète ne fonctionne pas.
Une idée?

merci par avance
Cdt
Logged
romain Chaillou
Newbie
*
Posts: 5


View Profile Email
« Reply #1 on: August 30, 2011, 10:05:38 AM »
Bonjour,
je me répond à moi même

j'ai ajouter un condition where dans la chaîne de where

Code:
$where = array();
$where[] = " ( ( offers.access >= 0 AND offers.access <= $user->gid ) OR ( offers.access = -1 AND $NeoRecruitConfig->access <= $user->gid ) ) ";
$where[] = " offers.published = 1 ";
$where[] = " categories.published = 1 ";
$where[] = " ( offers.publish_up = " . $db->Quote( $nullDate ) . " OR offers.publish_up <= " . $db->Quote( $now ) . " )";
$where[] = " ( offers.publish_down = " . $db->Quote( $nullDate ) . " OR offers.publish_down >= " . $db->Quote( $now ) . " )";
$where[] = " (offers.contact = " . $created_by.")";

le created_by est une variable perso
Logged
Raphael
Administrator
Hero Member
*****
Posts: 1619



View Profile WWW
« Reply #2 on: September 09, 2011, 12:19:17 PM »
Bonjour Romain,

Vous vous retrouviez effectivement avec 2 clauses "WHERE" dans votre requête. De plus, la condition que vous aviez ajoutée était mal placée, elle doit se trouver avec le "LEFT JOIN".

Cordialement,
Logged
Pages: [1] Print 
« previous next »
Jump to:  

Powered by SMF 1.1 RC3 | SMF © 2001-2006, Lewis Media
Joomla Bridge by JoomlaHacks.com
NeoJoomla is not affiliated with or endorsed by the Joomla! Project or Open Source Matters. The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
Professionnels Joomla | Joomla Components | Joomla Extensions | Joomla Templates | Joomla Design | Joomla Developers | Joomla Blog | Contact | Quote