Hi,
I have a column in a MySQL table which contains a counter of the views of the object described by this table. I would like to increment this value by one everytime the object is viewed. Obviously came into my mind the possibility of retrieving the value of this field, store it in a variable increment this value by one and perform an UPDATE query again with this new value. My question is if there is a MySQL option to update the field with its actual value plus an unit increment. I hope you understand the issue.

What you are trying to achieve can be done in a single SQL statement without the need to return any records... In fact, 1 simple update statement like:



Put that in a string and pass it to MySQL... I hope that helps!

I believe you can easily do that by going to your phpmyadmin and configurate the auto-increment fields and it'll make it a column there itself...

Auto-increment only works for insert statements, as it gives the next row a new ID number, but all previous rows will remain unaffected.

He wants to update an existing row (via code) and increment any one of the columns in it, thus the simple update statement I posted above would work fine for this purpose...

Thanks that was the solution i was looking for!!

Question answered: topic closed.

can i display upcoming row id in my form and can later fill all the information
Increment A Mysql Column

Hello all,

I want to display the upcoming record no which is autoincrement and when I open add form for fill data, id of that row I want to display and later I want to fill rest of the record. So is there any function in php so I can show this.

-question by Yogendra Mishra