Jump to content


This topic is now archived and is closed to further replies.


how do I update 1 table from data in multiple tables?

Recommended Posts

Hi all

I am using dreamweaver 8 to build an Fantasy Formula 1, data driven website, but this is not a dreamweaver specific question.

I have data that has been entered into various tables depending on results of a race, and want to update a leaderboard table with the results.

I have a users team table, which includes fields for: user team name, driver1, driver2, chassis etc

What I want to do is create a page, so that the end of the race, when data has been entered into the various tabes: qualify_results, Race_results, retirment_results etc to check the entered data and if a user a chosen has chosen a driver that has been awarded points, those points are entered into a new row in the leaderboard table, with any other points/penalties as appropriate.

Is anyone clever enough to guide me through the PHP logic? I am a newbie (still) and any help would be appreciated.


Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.