SELECT Q.QuestionID, Q.Titre, Q.Description, Q.Extrait, Q.Theme, Q.Suggestion, q.web, Q.Photo_mini, Q.Photo_texte,A.AnswerID, A.Answer FROM Question Q INNER JOIN Answer A ON Q.QuestionID=A.QuestionID WHERE Q.Repertoire_No=#attributes.Repertoire_No# AND Q.Nature='miniquiz' AND (Q.Actif='1' or Q.Actif='3') AND Q.Entree <= #CreateODBCDate("#now()#")# ORDER BY Q.QuestionID desc,A.tri;
class="features">
#Photo_mini#http://#Replace("#webpath#","http://","","ALL")#/images/#Photo_mini#" alt="#Suggestion#" title="#Suggestion#" border="0" ALIGN="MIDDLE">

#Titre#
#replace("#REReplace("#REReplace("#Extrait#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","ALL")#","#chr(13)##chr(10)#","
","all")#
#Description#
#Answer#

Voir les résultats