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.
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
?>