问显示某些用户数据的php查询(包括Smarty)

EN

table: sc_tables
+------+----------+-------------+
| t_id | user_id  | table_name  |
+------+----------+-------------+
|  1   |     1    | bobs        |
+------+----------+-------------+

table: sc_scores
+------+----------+-------------+-------+
| s_id | user_id  |    t_id     | score |
+------+----------+-------------+-------+
|  1   |     1    |      1      |  50   |
+------+----------+-------------+-------+

<?php
   include("config.php");
   session_start();

   $userId = (isset($_GET["user_id"]) && is_numeric($_GET["user_id"]) && (int)$_GET["user_id"] > 0) ? (int)$_GET["user_id"] : 0;

   $query = "SELECT `a`.`table_name` FROM `sc_tables` AS `a` JOIN `sc_scores` AS `b` ON `a`.`t_id` = `b`.`t_id`";

   $result = mysqli_query($db, $query);

     $rows = array();

     while ($row = mysql_fetch_array($result)) {
     $rows[] = $row;
     }

   $smarty->assign('rows', $rows); 
   include("header.php");
   $smarty->display('records.tpl');

 ?>

<div>
 <div>
    The current rankings table: 
    <table>

        {foreach from=$rows item="row"}
        <tr>
            <td>{$row.table_name}</td>
        </tr>
        {/foreach}

    </table>
 </div>
</div>