Pb requete SQL

Question

Bonjour,

Je récupère bien deux variables dateDebut et dateFIn (une ligne "echo" me le prouve) par contre je n'arrive pas à les utiliser dans ma requête SQL.

$sql = 'SELECT age_date,age_heure_debut,age_libelle FROM px_agenda WHERE age_util_id=1 AND age_date BETWEEN $dateDebut and $dateFin ORDER BY age_date';

Merci de me dire ce qui ne va pas dans ma synthaxe.

Gahel4

ted470 · Answer

essai 
$sql = 'SELECT age_date,age_heure_debut,age_libelle FROM px_agenda WHERE age_util_id=1 AND age_date BETWEEN '.$dateDebut.' and '.$dateFin.' ORDER BY age_date';
il ne faut pas oublier les quotes

dAv · Answer

Hello, pour plus de propreté, ecris plutot comme ça ;)


$sql  = "SELECT ";
$sql .= "age_date,age_heure_debut,age_libelle ";
$sql .= "FROM ";
$sql .= "px_agenda ";
$sql .= "WHERE ";
$sql .= "age_util_id=1 ";
$sql .= "AND ";
$sql .= "age_date BETWEEN ".$dateDebut." and ".$dateFin." ";
$sql .= "ORDER BY age_date";


Ca devrait marcher la je pense, tiens moi au courant!

gahel4 · Answer

Merci ted, Merci dav,

Pour votre aide.

En fait la solution est d'ecrire \"$dateDebut\"


$sql  = "SELECT ";
$sql .= "age_date,age_heure_debut,age_libelle ";
$sql .= "FROM ";
$sql .= "px_agenda ";
$sql .= "WHERE ";
$sql .= "age_util_id=1 ";
$sql .= "AND ";
$sql .= "age_date BETWEEN \"$dateDebut\" and \"$dateFin\" ";
$sql .= "ORDER BY age_date";

A+
Gahel4

Pb requete SQL

3 réponses

Discussions similaires

Newsletters