rating system

itworks

i have to develop a rating system but i can't figure out how to script it, here's the general idea.

this is for an administration area, users can submit a site URL in the main site and then in the administration area where only the 10 memebers of the jury have access with session login/password, the sites will be rated by each judge.

i want to make this as simple as possible and with the minimum number of clicks so i thought of displaying just a table with all the sites submited and for each one have a column of each judge and a total at the end.

But how can i make a drop menu with rating from 0 to 10 appear in the logged judge column for each site (row) and and then how can i update the database table with the ratings submited by that judge in the right database field (i have one for each judge)?

if you would be so kind to drop in your suggestions and considerations it could be of great help.

thanks in advance.

bad76

Hi,
try to check who is the user and assign the right column.

Then

if($column==$thisone)
{
// echo <select> tag with <option>
// you can also check what is CHECKED
} else {
// echo none or vote
}

itworks

thanks a lot for replying to my post!

i'm using session variables and one of them is the username so it's easy to accomplish what you suggested.

the other problem, the biggest one i think is how to store the votes of the user in his database column, i have one column for each member and i don't know how to make this query.

any more suggestions are apreciated!

thanks in advance.

bad76

You have
to distinguish two different case:

1) is the first vote for the user - is an insert
2) the user have already vote some site - is an update

You can look for different case just with a select (select * from table where user=$user) and count mysql_num_rows.

The sql statement may be like

$myquery="INSERT INTO table VALUES($user,";
for($i=0; $i<$ncheckbox; $i++)
                        $myquery.="'".$chkboxvalue[$i]."'";
$myquery.=")";

With update is the same.

itworks

i think i'm not explaining it the better way, these are the columns in the database.

id
site_name
site_url
email
judge1
judge2
judge3
judge4
judge5
judge6
judge7
judge8
judge9
judge10

now if i'm judge1 for example and i login to the site how to i store my votes for each site when i it the submit button (all sites are to be updated with the new vote not one at a time) i have to store in column judge1 for each row (site) the correspodent rate i submited.

i hope i made myself a little more clear this time, sorry if i didn't explain it better.

thanks in advance.

bad76

:eek: :eek: :eek:

one moment.... fumble fumble....

Well.

It's the same.
I understand that table are already fill with one record for site, so you don't have to check for insert, but just do an update, rigth?

The update my be just :
"UPDATE table SET judge".$column."='$vote' WHERE ID='$id'"
for each id that judge rate.

itworks

thanks a lot, your posts have been very helpful, i just need to figure out the rest, but i think i'll do ok 'cause some months ago i did another rating system that was way much harder to do than this.

thanks again!