join multiple table with specific row

Question

i have a question. i want to display nama from table staf that have same nric with nric from table tempahan. i try to do like code below but i just only error

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\New folder\permohonan_stk.php on line 120

can anybody help me?

    <?php
        include 'include\opendb.php';
        $i = "SELECT tempahan.tarikh_mohon, tempahan.tarikh, tempahan.masa_dari, tempahan.masa_hingga, tempahan.dari_daerah, tempahan.hingga_daerah, tempahan.tujuan, tempahan.status, staf.nama, staf.nric 
        from tempahan, staf
        WHERE staf.nric = tempah.nric";
        $h = mysqli_query($mysqli, $i);         
        $row=mysqli_fetch_array($h);



        while( $row1 ){

    ?>

    <tr>

        <td><center><?php echo $row['tarikh_mohon']; ?></center></td>
        <td><center><?php echo $row['nama']; ?></center></td>
        <td><center><?php echo $row['tarikh']; ?></center></td>
        <td><center><?php echo $row['masa_dari']; ?></center></td>
        <td><center><?php echo $row['masa_hingga']; ?></center></td>
        <td><center><?php echo $row['dari_daerah']; ?></center></td>
        <td><center><?php echo $row['dari_daerah']; ?></center></td>
        <td><center><?php echo $row['tujuan']; ?></center></td>
        <td><center><?php echo $row['status']; ?></center></td>
    </tr>
    <?php
        }

    ?>

[**see this too**](http://stackoverflow.com/questions/16756596/warning-mysqli-num-rows-expects-parameter-1-to-be-mysqli-result-boolean-give) :) — NoobEditor, Aug 29 '14 at 05:52
finally i got the answer. i need to check the query because the query is failing. — Nabila Fatin, Aug 29 '14 at 08:42

score 0 · Answer 1 · answered Aug 29 '14 at 05:56

Please see this:

$con=mysqli_connect("localhost","user","password","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$sql="SELECT tempahan.tarikh_mohon, tempahan.tarikh, tempahan.masa_dari,
 tempahan.masa_hingga, tempahan.dari_daerah, tempahan.hingga_daerah, tempahan.tujuan, tempahan.status, staf.nama, staf.nric 
from tempahan, staf WHERE staf.nric = tempah.nric";

$result=mysqli_query($con,$sql)

// Numeric array
$row=mysqli_fetch_array($result,MYSQLI_NUM);

 while( $row1 ){

    ?>
.....................
...............

For more refernce to mysql_fetch_array : http://php.net/manual/en/function.mysql-fetch-array.php

i already find the answer. i only need to check the query first.. tq fo helping me — Nabila Fatin, Aug 29 '14 at 08:44

join multiple table with specific row

1 Answers1