PHP - How to get all rows from a MySQL Query

Question

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.

Heads up! Future versions of PHP are deprecating and removing the mysql_ family of functions. Now would be a great time to switch to PDO or mysqli. — Charles
– Charles, Commented Dec 9, 2012 at 8:39
Also, please refrain from drastically rewriting a question as to make it entirely different. You have basically invalidated a set of previously given answers and wasted a great deal of time. It's poor form at best, and editors crankier than myself may choose to revert your massive rewrite. — Charles
– Charles, Commented Dec 9, 2012 at 8:41

Peter Krejci · Accepted Answer · 2012-12-09 08:17:53Z

9

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.

answered Dec 9, 2012 at 8:17

Peter Krejci

3,2126 gold badges34 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael King Over a year ago

thank you sir! You have solved an hours work. The reason ours wasn't working was because var_dump stopped the PHP script. I feel stupid

Martin Bean · Accepted Answer · 2015-05-12 13:06:53Z

0

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


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

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

print_r($res);

edited May 12, 2015 at 13:06

Martin Bean

39.6k28 gold badges134 silver badges208 bronze badges

answered Sep 11, 2014 at 11:11

Rizwan Gill

2,2631 gold badge20 silver badges29 bronze badges

1 Comment

Felix Frank Over a year ago

Can you try and enhance the formatting and add some explanation what the key points are?

Collectives™ on Stack Overflow

PHP - How to get all rows from a MySQL Query

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related