Hi!

  i want do a system to list my downloads with filename, filesize, date, comments and user rate. i already have the code to list my files with filename, filesize and date, but i dont know exactly what i need to include the comments and the user rate. have ideas?

You would need a form where people can input a comment, and a drop-down box or radio buttons for people to select a rating. Then save this to a database, and then display it in the appropriate place.

To actually calculate the rating, you might want to try "average rating * log10(number of votes)", so that it is more accurate when few people have rated it.

Blair

b_bonnet, thanks by your help

just a note; i dont need 10 options to rate... i want a very simple sysitm; just to say if the file have more porcent of coovotes or badvotes.

about the database and form; i have already all this done on my database and listing on page; i have "rate+" and "rate-" on database, and on myform it works like <% "rs.rate+" = "rs.rate+" + 1 %> and <% "rs.rate-" = "rs.rate-" + 1 %> ... but i dont know how to calculate tha rate+ and rate- to list the porcentage of rate+ and rate-... do you know how to do this? any more sugestions? thanks for all...

The following should work out what percentage of users have voted rate+ and rate-:

lngTotalVotes = "rs.rate+" + "rs.rate-"
lngRate+Percentage = (CInt((("rs.rate+" * 100) / lngTotalVotes) * 100)) / 100
lngRate-Percentage = (CInt((("rs.rate-" * 100) / lngTotalVotes) * 100)) / 100

Hope this helps,
Blair

uowwww... my god... "rate+" * 100 / "rate+" + "rate-" * 100 / 100 ... its very big confuzion to my mind...

im working now, but i will try this on this saturday, then i tell if it work.

thanks b_bonnett