[SOLVED] PHP SQL Help

[steviez]

Hi,

 

I am trying to get a table in my database to updae everytime the page loads, it will count how many times a video has been watched. I need to update 'no_of_times_viewd.

 

How is this done?

 

Thanks

[fert]

UPDATE `table` SET field=value+1 WHERE field=value

[hukadeeze]

To use the update statement you must first select the old value, then increment it by 1.

 

SELECT value

 

$value + 1

 

UPDATE value

[steviez]

But how do i get this to happen everytime my page loads?? im new to php

[hukadeeze]

If you place it on the same page as the video it will happen automatically. So every time that page is loaded, the code will run.