17.03.2014, 23:21
Try something like this:
the best was if to create a view in your database of a table and use this query, then it is always logged in the view.
the query is ceated to put the highest score on top.
if this helped you +rep.
if you need more information let me know.
PHP код:
select `YourDBName`.`players`.`username` AS `username`,`YourDBName`.`players`.`xp` AS `xp` from `YourDBName`.`players`
union
select `YourDBName`.`players1`.`username` AS `username`,`YourDBName`.`players1`.`xp` AS `xp` from `YourDBName`.`players1`
order by `xp` desc
the query is ceated to put the highest score on top.
if this helped you +rep.
if you need more information let me know.