[SOLVED] Table not updating - Code Included

[j152]

Hi all ...

 

I have been fighting with a database and losing....  I get no error messages, but my database table will not update...

 

// count rows & divide

$result = mysql_query("SELECT * FROM sample");

$num_row = mysql_num_rows($result);

$adjustment = $old_total / $num_row;

 

 

//update databse

$query = "UPDATE sample SET total = $adjustment WHERE boxes=9";

 

 

Any help would be greatly appreciated.

[j152]

Solved

 

I added

 

mysql_query($query);