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 ro
owed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DB] Re:data grabbing and mathematics!
1) use a single table, with 23 columns instead of 2. Then sum the columns
in your query.
Actually I disagree strongly unless your intention is to be able to read
the rows yourself !
As the stated intention
Neil Smith [MVP, Digital media] wrote:
At 17:15 07/03/2005 +, you wrote:
well - two options spring to mind...
1) use a single table, with 23 columns instead of 2. Then sum the
columns in your query.
- 1 query, no loops required.
2) have your script pull everything and add it all up.
- 22 qu
At 17:15 07/03/2005 +, you wrote:
JeRRy wrote:
Hi,
I have 23 tables, well I have more but these 23 tables
are the main agenda regarding this question.
In each of the table is a column titled "score" and a
column titled "nickname" ... These are the two columns
we need for this.
well - two option