update table problem, array related

ziah75

Im trying to update my table (which only contains one row with id=1), but can't get the UPDATE mySQL query working.
My query looks like this:

$result = mysql_query("UPDATE site_rating SET rating1 = '$read_rating['rating1']', rating2 = '$read_rating['rating2']', rating3 = '$read_rating['rating3']', rating4 = '$read_rating['rating4']', rating5 = '$read_rating['rating5']' WHERE id = 1");

My table rating contains fields id, rating1, rating2, rating3, rating4, rating5, no_of_votes

(The variable (ok, array element) $read_rating['rating1'] contains the new number to be sent into the field rating1)

If I use this query, then it works like charm:
mysql_query("UPDATE site_rating SET rating1 = '$slask', rating2 = '$slask' WHERE id = 1");

I guess there is some problem using statements like this in the update query?
$read_rating['rating5']

It doesn't work if i skip the ' around $read_rating['rating5'] in the query either...

Thanks for all help in advance.

/Anders

jsignor

a couple of thoughts....

1) assign the query to a variable i,e $query

2) append phrase or die("this is the query=> $query and this is the error").mysql_error()

3)this lets you see what the actual query looks like and what the error may be.

4) if the die clause doesn't fire (no error in query) you can at least echo the query to see what is actually going on

here is a snippet of a working update query much like the one you have.

            $query ="update admin SET ";
            $query=$query." NDASent='".$sess_form_admin["NDASent"]."'";
            $query=$query." ,NDAReceived='".$sess_form_admin["NDAReceived"]."'";
            $query=$query." ,RefsReceived='".$sess_form_admin["RefsReceived"]."'";
            $query=$query." ,BioReceived='".$sess_form_admin["BioReceived"]."'";
            $query=$query." ,Status='".$sess_form_admin["Status"]."'";
            $query=$query." ,DateActive='".$sess_form_admin["DateActive"]."'";
            $query=$query." ,ReferredBy='".$sess_form_admin["ReferredBy"]."'";
            $query=$query." ,Role='".$sess_form_admin["Role"]."'";
            $query=$query." where PeopleID= '$sess_peopleid'";

            $result = mysql_query($query) or die("Error in update Query: $query" . mysql_error());
            break;