loki951510

hi sorry that is almost right but i need cn1='blue' then then on the next click it would then be cn2='blue' ect

yes thats how i need to do it if poss i want to set pad_count to '15' and cn1 to 'cn15'

If i have both set like this they work $sql = "UPDATE users SET pad_count = (pad_count + $add_pad_count) WHERE username = '$session->username'"; $sql = "UPDATE users SET cn1='blue' WHERE username = '$session->username'"; but on the second UPDATE i need cn1 to be like cn$pad_count so it will turn the next block blue in the list how can i do this as its starting to drive me made i have been trying for about a week now to get this sorted thanks for the help in advance

Ch0cu3r yes that worked is their w way to echo out what it was before and after anyway like that?

i have this sql stament and i cant get it to work $sql2 = "SELECT pad_count FROM user WHERE pad_id = 1"; $sql = "UPDATE user ". "SET pad_count = ($sql2 + $pad_count) ". "WHERE pad_id = $pad_id" ; this is the error im getting from it can some one help me plz Could not update data: You can't specify target table 'user' for update in FROM clause