SELECT Votes FROM Answer WHERE QuestionID=#QuestionID# AND AnswerID=#AnswerID# UPDATE Answer SET Votes=#NewVotes# WHERE QuestionID=#QuestionID# AND AnswerID=#AnswerID# SELECT Q.Description, Q.Suggestion, q.web, Q.Reponse, Q.niveau2, Q.Theme, Q.Photo, Q.Photo_texte, SUM(A.Votes) AS TotalVotes FROM Question Q INNER JOIN Answer A ON Q.QuestionID=A.QuestionID WHERE Q.QuestionID=#QuestionID# GROUP BY Q.Description, Q.Suggestion, q.web, Q.Reponse, Q.Theme,Q.niveau2, Q.Photo, Q.Photo_texte SELECT A.Answer, A.AnswerID, A.tri,A.Votes,A.valeurq,A.Description,A.web,A.Suggestion FROM Answer A WHERE A.QuestionID=#QuestionID# ORDER BY A.tri
#Photo#http://#Replace("#webpath#","http://","","ALL")#/images/#Photo#" alt="#Photo_texte#" title="#Photo_texte#" border="0" ALIGN="MIDDLE">
#Description#
Vous avez répondu : #Answer#

Bonne réponse !

#Suggestion##web#

Mauvaise réponse !

#Suggestion##web#

#replace("#REReplace("#REReplace("#Reponse#","([[: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(10),"
","all")#

#Suggestion##web#
Portrait des réponses reçues
#Answer#
 #Percent# %   Bonne réponse !
 #Votes# réponses
#Int(TotalVotes)# personnes ont répondu à ce mini-quiz.