inserting data into a table

[freemancomputer]

I am having a problem with updating 2 table entry's at time. If i take out the num_votes it will add the rating. I'm not sure if I'm not doing the math correctly or if its not being entered correctly, then again I could be way off.

 

@mysql_select_db($database) or die( "Unable to select database");
$title = mysql_real_escape_string(urldecode($_POST["title"]));
$rating= mysql_real_escape_string($_POST['rating']);
$find_query="SELECT * FROM movie WHERE title='$title'";
$find_result=mysql_query($find_query);

$find_rating= mysql_result($find_result, $i, "rating");
$find_num_votes= mysql_result($find_result, $i, "num_votes")

$sum_rating = $find_rating + $rating;
$sum_num_votes = $find_num_votes + 1;


include"scripts/connect.php" ;
mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$title= mysql_real_escape_string($_POST['title']);
$error = '';

$sql_rating = "UPDATE movie SET rating='$sum_rating' num_votes='$sum_num_votes' WHERE title='$title'"; 
mysql_query($sql_rating) or die (mysql_error());

[awjudd]

You are missing a , between the two values that you are updating.

 

$sql_rating = "UPDATE movie SET rating='$sum_rating', num_votes='$sum_num_votes' WHERE title='$title'";

 

~awjudd

[freemancomputer]

even with the , in there it still dose not work.

[freemancomputer]

turns out i forgot a ; after

$find_num_votes= mysql_result($find_result, $i, "num_votes");