Is there a way to execute a subquery on a prepared statement result?

71 views Asked by At

I'm trying to find the statement results which have a specific userid column Here's the code:

$interazionequerystmt_string = "
    SELECT USERID 
    FROM like_calendario_condivisioni 
    WHERE TIPO LIKE ? AND COMUNE LIKE ? AND VIA LIKE ? AND CIVICO LIKE ?";
$interazionequerystmt = $con->prepare($interazionequerystmt_string);
$tipo = "LIKE";
$interazionequerystmt->bind_param("ssss", $tipo, $comune, $via, $civico);
$interazionequerystmt->execute();
$likesquery = $interazionequerystmt->get_result();
$ennesimaquery = mysqli_query($con, "
    SELECT * FROM ($likesquery) 
    WHERE USERID LIKE '$sessionuserid'");
0

There are 0 answers