phpBB.de

Code: Alles auswählen

$sql = "SELECT *
            FROM " . TVP_ROUT_TABLE . '
            WHERE tvp_unit_rout_user = ' . (int) $user_id . '
            AND tvp_unit_rout_id  = ' . (int) $tvp_last_rout . '
            ORDER BY tvp_unit_rout_real_id ASC';
           $result = $db->sql_query($sql);

            while ($row = $db->sql_fetchrow($result))
                {
                $rout_name     = get_rout_name($row['tvp_unit_rout_real_id']);
                
                $template->assign_block_vars('routloop', array(
                                            'ROUT_ID'                 => $row['tvp_unit_rout_real_id'],
                                            'ROUT_NAME'                => $rout_name,
                                            'ROUT_STYLE'            => $row['tvp_unit_rout_style'],
                                            'ROUT_TRAILS'            => $row['tvp_unit_rout_trails'],
                                            'ROUT_LINK'                => $row['tvp_unit_rout_real_id'],
                                            ));    
                }
                
        $db->sql_freeresult($result); 

Code: Alles auswählen

 function get_rout_name($row['tvp_unit_rout_real_id'])
{
    global $db;
        
    $sql = "SELECT *
            FROM " . CR_CR_LINE_TABLE . '
            WHERE cr_cr_line_id = ' . (int) $row['tvp_unit_rout_real_id'];
           $result = $db->sql_query($sql);

            while ($row = $db->sql_fetchrow($result))
                {
                $cr_line_name               = $row['cr_cr_line_name'];
                }
    $db->sql_freeresult($result);

    return $cr_line_name;
} 

Code: Alles auswählen

function get_rout_name($row['tvp_unit_rout_real_id'])

Code: Alles auswählen

function get_rout_name($tvp_unit_rout_real_id)

Code: Alles auswählen

WHERE cr_cr_line_id = ' . (int) $row['tvp_unit_rout_real_id'];

Code: Alles auswählen

WHERE cr_cr_line_id = ' . (int) $tvp_unit_rout_real_id;