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.Url, 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.Url, Q.Reponse, Q.Theme,Q.niveau2, Q.Photo, Q.Photo_texte SELECT A.Answer, A.OrderNum, A.Votes 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#

#Answer#

#Percent# %

#Votes# votes

#Int(TotalVotes)# personnes ontpersonne a répondu à ce mini-sondage.

#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##Url#