Trying to use SELECT, WHERE and LIKE with a variable doesn't work

There is one burning issue in this, and that is the following code;

$sqlout1f = "SELECT source FROM pagetable WHERE output LIKE 'out1f'";
$resultout1f = mysqli_query($conn, $sqlout1f);
$sqlout1fsrc ="SELECT streamurl FROM tablestream WHERE vanrole LIKE '{resultout1f}'";
$resultsqlout1fsrc = mysqli_query ($conn,$sqlout1fsrc);

If you add the $ to the second of the queries, where you use the variable, you are using a resource, not a string, this is because $resultout1f is the result from the first query, i.e. a dataset, not a data result, you need to get the information out of the result set before you can use any of it in a secondary query

You are using the LIKE clause in the Wrong manner. Here is the basics of LIKE clause:

LIKE is normally used in 3 ways :

1.) LIKE '%[STRING]%' - This specifies that your [STRING] can be at any position.

2.) LIKE '[STRING]%' - This Specifies the condition that it should start with your [STRING]

3.) LIKE '%[STRING]' - This Specifies the condition that it should end with your [STRING]

Coming to your problem. You can modify your statements to use placeholders and later repplace the placeholders with the actual value like mentioned below:

$sqlout1f = "SELECT source FROM pagetable WHERE output LIKE '%out1f%'";
$sqlout1fsrc ="SELECT streamurl FROM tablestream WHERE vanrole LIKE '%[resultout1f]%'";
$resultout1f = mysqli_query($conn, $sqlout1f);

If your Row Count is equal to 1:

$row = mysqli_fetch_array($resultout1f, MYSQLI_ASSOC);
$sqlout1fsrc = str_replace('[resultout1f]', $row['source'], $sqlout1fsrc);
$resultsqlout1fsrc = mysqli_query ($conn,$sqlout1fsrc);
while($row = mysqli_fetch_array($resultsqlout1fsrc, MYSQLI_ASSOC)) {
    echo $row['streamurl'];
}

If your Row Count is Greater Than 1:

while($row = mysqli_fetch_array($resultout1f, MYSQLI_ASSOC)) {
    $sqlout2fsrc = $sqlout1fsrc;
    $sqlout2fsrc = str_replace('[resultout1f]', $row['source'], $sqlout2fsrc);
    $resultsqlout1fsrc = mysqli_query ($conn,$sqlout2fsrc);
    while($row2 = mysqli_fetch_array($resultsqlout1fsrc, MYSQLI_ASSOC);) {
        echo $row2['streamurl'];
    }
}

You can find more information on LIKE clause Here.

Hope this helps.

You should bind your query string with %% while using LIKE

SELECT * FROM TABLE WHERE COLUMN LIKE "%query%"

%a => anything that ends with a like santa, comma
a% => anything that starts with a like application, answer
%a%=> anything that has a in middle cat ,madam