> I am not sure if this is possible or not or in what
> format etc. Maybe it's a PHP, mysql or even a
> if people are aware if it is possible for what I want
> to do. I have searched alot on the net and yet have
> not come accross what I am looking for, so posting
> here may get me pointed in the right direction. Okay
> here is what I wanna do. :)
> I have a list of users in multiple tables in the one
> database. Each user has a field named 'score'. As
> the table numbers go higher generally the score goes
> higher but never lower than the previous table. There
> are 22 tables named 1 to 22. So an example is below:
First of all, why do you have 22 tables???
It would be much more efficient using only ONE.
It would include the fields:
or something like that. MySQL can easily order them by score.
SELECT user, score
ORDER BY score
MySQL can also get the total score.
So, I would call this a MySQL subject. Think over your database design.
Once a problem is defined - it is half way solved. (Henry Ford)
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php