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, May 15 '17 at 23:44

score 0 · Answer 1 · answered May 16 '17 at 00:10

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 '17 at 00:10

Pyae Sone

1,574
2
14
18

thanks for the answer, but result printed why just from tbl B? can you explain this?thanks – Herlambang Permadi May 16 '17 at 01:04
Check these post. [mysql-fetch-array-mysql-fetch-assoc-mysql-fetch-object differences](http://stackoverflow.com/questions/1536813/mysql-fetch-array-mysql-fetch-assoc-mysql-fetch-object) – Pyae Sone May 16 '17 at 05:21

PHP SQL: select data from 2 tables

1 Answers1