Okay I have this:

$sql = "UPDATE round" . ($round_number -1) . " SET
score=score+1 WHERE $select='$winner'";

Which works as it should.

Now after all that is completed how is the best way to
retrieve the nickname and the score in that round and
update another table?

Okay two tables, one is round5 (for instance) and the
other is tipping.

So ....

round5 table:
Nickname:         Score:
Bob               5
Bill              4
Fred              3

So I want to grab each nicknames score and UPDATE the
tipping table.

tipping table:
Nickname:        Score:
Bob              24
Bill             31
Fred             30

So we need to add 5 for bob and 4 for bill and 3 for
fred on top of their current score.  So for instance
Bob would go to 29.

What is the best way to do this?  I need the nicknames
round score to update their total score and be
reliable to update the right nickname.

This would solve a bit of my time mucking around and
re-structuring my database until I have more time. :)

If you need more information please let me know.


Find local movie times and trailers on Yahoo! Movies.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to