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.