CODEWITHSUNDEEP
phpmysql
Michael King
Michael King

Reputation: 638

PHP - How to get all rows from a MySQL Query

This is my code: 

if($login_check > 0) {
    $results = mysql_query("SELECT * FROM messageInfo WHERE senderUsername='$username' UNION ALL SELECT * FROM messageInfo WHERE recieverUsername='$username';");
    var_dump(mysql_fetch_assoc($results));

}

I'm getting only one row "var_dumped", when I should be getting two rows returned.

Upvotes: 1

Views: 44790

Answers (2)

Rizwan Gill
Rizwan Gill

Reputation: 2253

  $sqlriz = "Select * FROM `tablename`";


    $Rslt = mysqli_query($Conn,$sqlriz);

    while($r=mysqli_fetch_object($Rslt))
    {
        $res[]=$r;
    }

print_r($res);

Upvotes: 0

Peter Krejci
Peter Krejci

Reputation: 3192

Try following code:

$result = mysql_query("SELECT * FROM messageInfo WHERE senderUsername='$username' OR recieverUsername='$username'");

while ($row = mysql_fetch_assoc($result)) {
    print_r($row);
}

I think that UNION is not really needed in this query, OR statement would be just enough.

Upvotes: 9

Related Questions