mysqli_query数据库选择错误

Question

Im trying to select text from a database but only the text that was posted by certain usernames. Basically I need someone to look at this PHP and MySQL code and tell me what they see is wrong with it. I hope I have given enough info. Also, I get this erro: Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, string given in... Thanks! Here is the code:

$followed = mysqli_query($con,"SELECT followed FROM follows WHERE follower = '$username'");

while($row = mysqli_fetch_array($followed)){

    echo $row['followed']."<br>";
    $followed = $row['followed'];

    $random = mysqli_query($con,"SELECT text FROM post WHERE user = '$followed'");

    while($row = mysqli_fetch_array($random)){
        echo "<ul><li id = 'stream-post'>";
        echo $row['text'];
        echo "</li></ul>";
        $user = $row['user'];
    }
}

Answer 1

Just as a hint: the second loop assigns the result to row which already holds the row from the first query. Use a different variable name:

    ...
    while($row = mysqli_fetch_array($followed)){

    echo $row['followed']."<br>";
    $followed = $row['followed'];

    $random = mysqli_query($con,"SELECT text FROM post WHERE user = '$followed'");

    while($subrow = mysqli_fetch_array($random)){
        echo "<ul><li id = 'stream-post'>";
        echo $subrow['text'];
        ....

second: column useris not part of either SELECT (... $user = $row['user'];)

I assume, it's the second query:

     "SELECT user, text FROM post WHERE user = '$followed'"