JeRRy wrote:

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.
Now I want the scores added up.  So using the + not *
(times) but just adding.  So for Bob is 5 + 3 = 8 and
this figure must than be placed in another table with
that name.

What I want to do is just have one code written up so
I don't need to change it.  So in other words the code
would include all 22 tables and the method to add each
other together and update to the actual main scoring

So the score aRE updated once a week.  I don't mind if
I need to trigger the update (preffered) from a php
page/script.  That's not the problem but I want to
know what code I would use to grab these details and
add them up using all 22 tables in the one script.  So
each time the script is ran it will re-calculate all
tables to make sure they are correct if an update is
made to a score.

So the script would grab all 22 tables score and
nickname and than match the nickname and update their
score in the scoring table.

What I have is this:

My Tables are round 1 through to round22 and the
scoring totals go into table called tipping.

So round1 through to 22 need to be calculated and
keeping the totals for each nickname correct with
their totals.  Don't want the scores to be jumbled
with a different nickname.

How would I do this that would be a pretty fast
process and reliable?

If you need more information please let me know.  Each
round table will have identical Nicknames in each,
none will have more or few, same amount.

Keeping in mind each round that has not had a total
set is defaulted as nothing in the score field, it's
blank.  But if it's required to have a value of 0 in
there for the calculations to work I can default this

If anyone can help me here it would be great, I have
been stuck on this for a while. There is only going
to be like 15 names max in each round to do totals for
so it's not a huge database.

Thanks for your time.
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 queries, a loop for each, array storing scores & indexed by name.

anything else is going to be a join from hell. With only 22 tables and 15 rows in each table, you literally won't be able to blink before either of these methods would be finished calculating your totals.

Whatever you code up will be as reliable as the code used for it :)

A better question to ask is, will this be something that cycles yearly or regularly? If so, you'll want to be storing some identifier for the event/session/quarter/year/etc. - in which case any join option would be insanely further compliated, and all of your queries would need the chunk added.

- Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to