PHP Extracting MYSQL Value Issue

Question

I have 2 tables: users and transactions

In users I have: userid, name, email

And in transactions I have: id, idsender, idreceiver

I want to make a log-table showing all the transactions and I want them to be displayed like: Transaction ID - SENDER'S NAME - RECEIVER'S NAME

I tried like this but it doesn't seem to work, at "Receiver" it doesn't show anything .. :

echo "<table>";
echo "<tr>";
echo "<th>Transaction ID</th>";
echo "<th>Sender</th>";
echo "<th>Receiver</th>";
echo "</tr>";

    $resultuser = mysqli_query($conn, "SELECT * FROM users"); 
    $rowuser=mysqli_fetch_array($resultuser);

    $resulttrans = mysqli_query($conn, "SELECT * FROM transactions"); 
    $rowtrans=mysqli_fetch_array($resulttrans);



    $ress=mysqli_query($conn, "SELECT * FROM transactions");

            while($row=mysqli_fetch_array($ress)){
                echo "<tr>";
                echo "<td>".$row['id']."</td>";
                echo "<td>"." same as receiver"."</td>";
            $receiver=mysqli_query($conn, "SELECT name FROM users WHERE userid='" . $rowtrans['idreceiver'] . "'");
            $receivername = mysqli_fetch_array($receiver);

                echo "<td>". $receivername ."</td>";
                echo "</tr>";
            }

See the documentation. mysqli_fetch_array returns an array or null, and you're trying to output as a simple variable. — cteski
– cteski, Commented Nov 16, 2017 at 23:00
Don't use two queries, use one query that joins the two tables. — Barmar
– Barmar, Commented Nov 16, 2017 at 23:09

Barmar · Accepted Answer · 2017-11-16 23:14:43Z

1

Don't use two queries. Join the two tables in one query:

$ress = mysqli_query("SELECT t.id, u1.name AS sendername, u2.name AS receivername
    FROM transactions AS t
    JOIN users AS u1 ON u1.userid = t.idsender
    JOIN users AS u2 ON u2.userid = t.idreceiver");
while ($row = mysqli_fetch_assoc($ress)) {
    echo "<tr>";
    echo "<td>".$row['id']."</td>";
    echo "<td>" . $row['sendername'] ."</td>";
    echo "<td>" . $row['receivername'] . "</td>";
    echo "</tr>";
}

answered Nov 16, 2017 at 23:14

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Comments

Aaron Magpantay · Accepted Answer · 2017-11-16 23:00:08Z

0

You are echoing from fetched array in $receivername = mysqli_fetch_array($receiver);

you should do echo "<td>". $receivername['name'] ."</td>";

Note: Fetched array from mysqli_fetch_array() can be echoed using indexes by number $receivername[0] or by string $receivername['name'], that is where you are missing here.

answered Nov 16, 2017 at 23:00

Aaron Magpantay

4051 gold badge5 silver badges17 bronze badges

3 Comments

Dizzy Tudor Over a year ago

Still not working,

$receiver=mysqli_query($conn, "SELECT * FROM users WHERE userid='" . $rowtrans['idreceiver'] . "'");   	$receivername = mysqli_fetch_array($receiver); 	              echo "<td>". $receivername ."</td>";

Barmar Over a year ago

@DizzyTudor That's the same as your question, not like the answer.

Dizzy Tudor Over a year ago

@Barmar sorry, I ment $receivername['name'], I pasted it wrong. I have it correct now, but the field is still blank.

Collectives™ on Stack Overflow

PHP Extracting MYSQL Value Issue

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related