将变量直接插入
SELECT
:
$secondary_types = [
[1, 'compilation', 'recopilatorios', $config['uri']['discography_compilation']],
[10, 'original', 'original', $config['uri']['discography_original']],
[11, 'colaboration', 'colaboraciones', $config['uri']['discography_colaboration']],
[12, 'other', 'otros', $config['uri']['discography_other']]
]
$q = [
'query' => "SELECT $secondary_types[1][1] catname, rl.release_id, rl.name rlname..."
];
我得到一个错误:
Notice: Array to string conversion
$secondary_types = [
[1, 'compilation', 'recopilatorios', $config['uri']['discography_compilation']],
[10, 'original', 'original', $config['uri']['discography_original']],
[11, 'colaboration', 'colaboraciones', $config['uri']['discography_colaboration']],
[12, 'other', 'otros', $config['uri']['discography_other']]
]
$tmp = $secondary_types[1][1];
$q = [
'query' => "SELECT '$tmp' catname, rl.release_id, rl.name rlname..."
];