mysql selecte,Mysql查询获取select perticulare列

I have one table contain following columns

Id,imagename,countRate

there are many rows in table containing different imagesname.

those all images are shown into the front end, after clicking on button with each image increment the countRate of that image. My difficulty is that how can I know that any perticulare countRate is for respected imageName. in where clause what should i have to mention as Id is not known to me.

What I have tried:

I have one table contain following columns

Id,imagename,countRate

there are many rows in table containing different imagesname.

those all images are shown into the front end, after clicking on button with each image increment the countRate of that image. My difficulty is that how can I know that any perticulare countRate is for respected imageName. in where clause what should i have to mention as Id is not known to me.

解决方案This is not possible without setting a PK (primary key) field. This will allow you to identify each column uniquely. If you don't know the ID for the row then set 2 (two) PKs.

WHATS NEXT?

Now you can pick the ImageName from a data control like gridview, datalist or repeater, whenever the ImageName is collected you just have to check the same row for column ID and use it to get the countRate or maybe pick countRate directly from the datarow in the control.

Hope this helps