mysql查询在循环内部不起作用

Question

I have written this code`

$serial_no = 1; 
while($rowss = mysqli_fetch_array($selectQuery))
echo $rowss['work_date'];
$mauzaNameQry = mysqli_query($conn,"select moza_name from moza_names where          mauza_id =1");
echo mysql_error();
$mauzaNameRslt = mysqli_fetch_array($mauzaNameQry);
`echo $rowss['work_date'];
`

it does not return me anything in $rowss[] array when I write another query of select inside loop as I have written above select query inside while loop which selects data from moza_name table. $rowss[] shows data if I remove inside query of moza_name table. It even doesn't show any error's.

Answer 1

I'm not really sure what you are trying to do, but this may be it?

<?php
    $serial_no = 1;
    while($row = mysqli_fetch_array($selectQuery)) {
        echo $row['work_date'];
    }
    $mauzaNameQry = mysqli_query($conn,"SELECT moza_name FROM moza_names WEHRE `mauza_id`='1'") or die(mysqli_error($mauzaNameQry));
    while($row = mysqli_fetch_array($mauzaNameQry)) {
        echo $row['work_date'];
    }
?>

UPDATE:

Are you trying to do a nested loop?

    <?php
    $serial_no = 1; 
    while($rowss = mysqli_fetch_array($selectQuery)) {
    echo $rowss['work_date'];
        $mauzaNameQry = mysqli_query($conn,"SELECT moza_name FROM moza_names where `mauza_id`='1'") or die();
        while($mauzaNameRslt = mysqli_fetch_array($mauzaNameQry)) {
            echo $mauzaNameRslt['work_date'];
        }
    }
?>

UPDATE 3:

<?php
        $userId = 1; //ID to search for
        $ID = mysqli_query($conn,"SELECT * FROM work_sheet where `mauza_id`='$userId'") or die(); //get ID and if it doesn't exist, exit
        $IdFromTable1 = $ID['moza_id']; // set the correct ID from table1
        $mauzaNameQry = mysqli_query($conn,"SELECT * FROM moza_names where `mauza_id`='$IdFromTable1'") or die(); //check for table1's correct ID on table2
        echo $mauzaNameRslt['moza_name']; //echo the name from table1's ID
?>