hi guys

This is my first post and I really hope someone can help me out. I’m working with Dreamweaver 8 and developing using PHP. I think some of you might easily have an answer to my question since I’m a newbie.

I have a database with 2 tables:

“users” table with fields like:
- name
- city (int)
- and many more fields…

“cities” table with fields like:
- cityID (int)
- cityName
- and more fields
- cityCounter (default is 0)

users.city is related to cities.cityID

Now here is my problem:

I created a registration form where the user fills in all his information and when he clicks on submit data is submitted to the database. This part is working perfectly.

<b>What I want to do is also increment the “cityCounter” of the chosen city by 1 when the user clicks on submit. </b> I’ve been trying to figure out how for like 5 hours now and still can’t do it

Note that I’m barely writing any bare php and I’m using all of dreamweavers tools. Hope someone cane help out please.