# Adding 1 to a page\_count field

**URL:** <https://forum.kirupa.com/t/adding-1-to-a-page-count-field/280314>\
**Category:** programming\
**Created:** [January 26, 2009, 5:26am UTC](https://forum.kirupa.com/t/adding-1-to-a-page-count-field/280314 "2009-01-26T05:26:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasonhardwick](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@jasonhardwick](https://forum.kirupa.com/u/jasonhardwick)\
**Post date:** [January 26, 2009, 5:26am UTC](https://forum.kirupa.com/t/adding-1-to-a-page-count-field/280314/1 "2009-01-26T05:26:15Z")

</div>

So i need to add 1 to the INT in my “play\_count” field each time this script is executed.

```auto

$sql1="UPDATE Movies SET play_count = play_count+1 WHERE id = 'id'";
$result1 = mysql_query($sql1) or die (mysql_error());

if($result1)
{
echo "YES"."<BR/>";  
}
else
{
echo "Error";
}

```