Hi.. 1- In my mySQL DB there is a field named "Whole".. there are many rows.. and every one has the value for the field "Whole".
What I want is to add all these values in all rows for the field "Whole" then show it on the screen.. I mean by add : 1 + 2 + 3 = 6... 2- I have another filed there also.. named "UserNo" I want every adding query to this field to include a value in the row for that field = the latest row's value + 1 For example : if there are three rows in the table.. Row1 : "UserNo" value = 1 Row2 : "UserNo" value = 2 Row3 : "UserNo" value = 3 I want PHP to get the last row's value for that field (In this example : 3) then add to it 1.. so it will be 4 and insert it to the new row.. Regards..