Hot to plus the vote score into data base

[paitoon]

Hello,
I have problem to add vote to the data base . In the form i have radio button to choose to rate the score 1 2 3 4 5 ....and when i click to submit this the score in database is changed by the score i chose but it not plus it selv....what should i do.

here is my code :

$id_vdo=$_POST['id_vdo'];
$name_vdo=$_POST['name_vdo'];
$rate=$_POST['rate'];
 
include "connect.php";
    $sql = "select vote from vdo where id='$id_vdo'";
    $result = mysql_db_query($dbname,$sql);
    $r=mysql_fetch_array($result);
                $org_vote=$r[0];
        $org_vote++;
        $sql="update vdo set vote='$org_vote' where id='$id_vdo'";
        $result=mysql_db_query($dbname,$sql);
 
 
 

Actually I think this is wrong because i dont know how to plus the new vote with the vote in database and make it change properly.

thanks
Paitoon

[pbmods]

Heya, Paitoon.

Try this:

$sql="UPDATE `vdo` SET `vote` = `vote` + 1 WHERE `id` = '{$id_vdo}' LIMIT 1";
 

[ronverdonk]

According to your post you want to update the value in the database with the chosen value, i.e. 1-5. So you increment the count with the selected value (1-5). You do that by statement
[php]$org_vote+=$rate;[/php]
But what I do not see is the number of votes increasing. When you want to calculate an average vote, I think you have the total number of rates divided by the number of votes. So if you have 3 votes, e.g. rates 2,3,5, and a total of 3 votes, the average vote would be 3.3.

Ronald

[pbmods]

Heya, Paitoon.

Please use CODE tags when posting source code:

[CODE=php]
PHP code goes here.
[/CODE]

[pbmods]

Merged duplicate threads.

[paitoon]

Very superb
thanks so much :-)
PAitoon