How to build a page to execute a query
Posted: Tue Jan 04, 2011 11:18 pm
Hi
Have this query:
UPDATE `mydatabase`.`xxscrs` SET `RP_bill`=(SELECT SUM(xxscrs.player_total)*50)
Have run the query from my cpanel in phpmyadmin and it does what I want it to do. Obviously it updates the whole table and calculates a players "ranking points"
What I would like to do is now build a page in the database so when scores have been inserted into the "xxscrs" table, it can then be updated.
Not sure where to start
Any help would be greatly appreciated.
Have this query:
UPDATE `mydatabase`.`xxscrs` SET `RP_bill`=(SELECT SUM(xxscrs.player_total)*50)
Have run the query from my cpanel in phpmyadmin and it does what I want it to do. Obviously it updates the whole table and calculates a players "ranking points"
What I would like to do is now build a page in the database so when scores have been inserted into the "xxscrs" table, it can then be updated.
Not sure where to start
Any help would be greatly appreciated.