31/12/2022, 04:45 PM
buenas tengo esta consulta
y quiero hacer un cambio y es que en la parte del query de la ultima linea quiero reemplazarla por esta consulta
como puedo integral la variable $ext_query
intento de esta manera
pero me da este error Error en la consulta: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LEFT JOIN pug_playerstats ON pug_playerstats.player_steamid = amx_bans.player...' at line 1
Código PHP:
$ext_query = "";
if(isset($_GET['id'])){
$ext_query = " where bid=".$_GET['id'];
}
$dbTable = "amx_bans";
$query = $db->query('SELECT * FROM '.$dbTable) or die ("Error: ".mysqli_error($db));
$query = $db->query('SELECT server_name, bid, player_id, player_ip, ban_created, player_nick, admin_nick, admin_id, admin_ip, ban_reason, ban_length, expired FROM '.$dbTable .$ext_query ) or die ("Error en la consulta: ".mysqli_error($db));
y quiero hacer un cambio y es que en la parte del query de la ultima linea quiero reemplazarla por esta consulta
Código PHP:
$query = $db->query('SELECT amx_bans.*, pug_serverstats.pug_index, pug_serverstats.pug_hash FROM amx_bans LEFT JOIN pug_playerstats ON pug_playerstats.player_steamid = amx_bans.player_id LEFT JOIN pug_serverstats ON pug_serverstats.pug_index = pug_playerstats.pug_index ORDER BY bid') or die ("Error en la consulta: ".mysqli_error($db));
como puedo integral la variable $ext_query
intento de esta manera
Código PHP:
$query = $db->query('SELECT amx_bans.*, pug_serverstats.pug_index, pug_serverstats.pug_hash FROM amx_bans '.$ext_query.' LEFT JOIN pug_playerstats ON pug_playerstats.player_steamid = amx_bans.player_id LEFT JOIN pug_serverstats ON pug_serverstats.pug_index = pug_playerstats.pug_index ORDER BY bid') or die ("Error en la consulta: ".mysqli_error($db));
pero me da este error Error en la consulta: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LEFT JOIN pug_playerstats ON pug_playerstats.player_steamid = amx_bans.player...' at line 1