PHP SQL: select data from 2 tables

Question

I have 2 tables

Tbl A Cols : id nama kdwil

Tbl B Cols : id nama kdwil

Want show all data from that tables which kdwil is somevalue

So, I did

    $query2 = "SELECT * FROM a, b where a.kdwil=b.kdwil and a.kdwil='$kdwil'";
    $result2 = mysql_query($query2);
    while($row2 = mysql_fetch_array($result2)){ 
        echo "<label><input type='checkbox' value='".$row2['nama']."'>".$row2['nama']."</label>";

But returned no results.

You should be using PDO / MySQLi, mysql_* functions are deprecated. — Enstage
– Enstage, Commented May 15, 2017 at 23:44

Pyae Sone · Accepted Answer · 2017-05-16 00:10:47Z

0

$query2 = "SELECT * FROM a, b where a.kdwil=b.kdwil and a.kdwil='$kdwil'";
$result2 = mysql_query($query2);
while($row2 = mysql_fetch_assoc($result2)){ 
    echo "<label><input type='checkbox' value='".$row2['nama']."'>".$row2['nama']."</label>";

Use mysql_fetch_assoc instead.

answered May 16, 2017 at 0:10

Pyae Sone

1,6342 gold badges16 silver badges18 bronze badges

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

2 Comments

Herlambang Permadi Over a year ago

thanks for the answer, but result printed why just from tbl B? can you explain this?thanks

Pyae Sone Over a year ago

Check these post. mysql-fetch-array-mysql-fetch-assoc-mysql-fetch-object differences

Collectives™ on Stack Overflow

PHP SQL: select data from 2 tables

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related