i am writing a program and i need to increment a table row. How would i increment a table row on the click of a button?

It depends on what you mean by increment the table row. If you are referring to incrementing it for insert then simply create the field as an auto-increment in MySQL and the database will auto-increment the field for you.

If you are simply trying to get to the next record in the table then post the current record_ID into a new field and add one to it. Then select the record where the record_id equals the new variable.

ok, lets say there are 2 rows. one that username. the username is john.
the next one is number. the number is 1. I want onclick 1 is added to the number. so after one click the row would be 2. after another the row would be 3

Are you sure you shouldn't be using javascript for this, instead of PHP?

Member Avatar

The database row should be incremented automatically. If you set autoincrement to your primary key.

Is that what you're getting at? *confused.ardav*

if you want to increment row dinamically the best way is to use Javascript