techPowerUp! Forums - View Single Post - Website using PHP and MySQL... How do I update a field every hour?

Akumos · Aug 7, 2012, 08:01 PM

Hi All

For a pass-time, I am making a text based browser game using PHP... I have a mysql database that the website reads information from. My question is, i have a field in a player table called 'gold'. How do i increase it by 1 every hour?

Thanks

Aug 7, 2012, 08:01 PM	#1
Akumos Join Date: Nov 2008 Location: Birmingham, England... Posts: 474 (0.29/day) Thanks: 73 Thanked 27 Times in 22 Posts System Specs	Website using PHP and MySQL... How do I update a field every hour? Hi All For a pass-time, I am making a text based browser game using PHP... I have a mysql database that the website reads information from. My question is, i have a field in a player table called 'gold'. How do i increase it by 1 every hour? Thanks __________________

Processor:	Intel Core 2 Quad Q6600 @ 2.8GHz
Motherboard:	Gigabyte X48T-DQ6
Cooling:	Zalman 9500 LED CPU Cooler
Memory:	2x 2GB Corsair DDR3 XMS3 DHX - 1600MH/PC3-12800
Video Card:	Gigabyte HD4870 1GB
Hard Disk:	2x Seagate 320GB Barracuda (RAID 0) 3x 1TB Samsung F3, 140GB WD Maxtor (10,000rpm)
CRT/LCD Model:	2x 20" LG Flatron L204WS
PSU:	Powercool 850W
Software:	Windows 7 Ultimate x64