no, that is the wrong output. I can't see any way that it is possible for you to get that output. The query you just echoed is too different from $query.
First, plt_no should = "plt_no", not
d.operation_name, SUM(d.input_qty) AS inputqty, d.input_unit, SUM(d.output_qty) AS outputqty, d.output_unit, d.shift
and plt_transact should = "plt_transact" not
clt_traceability d, clt_transact t
BETWEEN is not even listed in the query you echoed. The query you posted is also more complicated. If you want us to look at the more complicated query or even the simpler query we need you to post the data types as well. Possibly the output too, but at present I don't see a need to see a portion of the output. If you want you can post it as well. It couldn't hurt and could help.
Here is the full code:
if($_POST["start_date"])
{
$query = "SELECT plt_no FROM plt_transact WHERE plt_date = '" . $_POST["start_date"] . "'";
$result_loop = mysql_query($query);
$date = $_POST["start_date"];
$Batch_yield = 0;
$buff_input = 0;
$core_output = 0;
$loopctr = 0;
$totalloop = 0;
/***Header****/
if($result_loop) if(mysql_num_rows($result_loop) > 0)
{
$totalloop = mysql_num_rows($result_loop);
$plt_no = mysql_result($result_loop,0,"plt_no");
$query = "SELECT d.operation_name, SUM(d.input_qty) AS inputqty, d.input_unit, SUM(d.output_qty) AS outputqty, d.output_unit FROM traceability d, plt_transact t WHERE t.plt_no = '$plt_no' AND d.plt_transact_id = t.plt_transact_id GROUP BY d.operation_name, d.output_unit, d.input_unit ORDER BY d.operation_name";
$result = mysql_query($query);
if($result)
{
echo "<table cellspacing='2' style='font-family: arial narrow; font-size: 12px; border-width: 2px 2px 2px 2px; border-style: solid;'>";
echo "<tr>";
echo "<tr><b> Date: " . $date . "</b></tr>";
echo "<th class='tdclass'>PLT #</th>";
$total_row = mysql_num_rows($result);
for($ctr=0; $ctr < $total_row; $ctr++)
{
$opname = mysql_result($result,$ctr,"operation_name");
$i = strpos($opname," ",0);
$opname = substr($opname,$i);
echo "<th colspan='2' class='tdclass'>" . $opname . "<br />(" . mysql_result($result,$ctr,"output_unit") . ")</th>";
}
echo "<th class='tdclass'>PLT Yield</th>";
echo "</tr>";
echo "<tr>";
echo "<td class='tdclass'></td>";
for($ctr=0; $ctr < $total_row; $ctr++)
{
echo "<td class='tdclass'>Input</td>";
echo "<td class='tdclass'>Output</td>";
}
echo "<td class='tdclass'>";
echo "</td>";
echo "</tr>";
}
}
$query = "SELECT plt_no FROM plt_transact WHERE plt_date = '" . $_POST["start_date"] . "'";
$result_loop = mysql_query($query);
while($row = mysql_fetch_array($result_loop))
{
$loopctr += 1;
$plt_no = $row["plt_no"];
$query = "SELECT * FROM plt_transact WHERE plt_no = '$plt_no'";
$result_no = mysql_query($query);
if($result_no)
{
if(mysql_num_rows($result_no) > 0)
{
$f_output = 0;
$c_output = 0;
$query = "SELECT SUM(t.output_qty) AS f_output FROM traceability t, plt_transact p WHERE t.plt_transact_id = p.plt_transact_id AND t.operation_name='05 F' AND p.plt_no = '$plt_no'";
$resultyield = mysql_query($query);
if($resultyield)
{
if(mysql_num_rows($resultyield) > 0) $f_output = mysql_result($resultyield,0,"f_output");
}
$query = "SELECT SUM(t.output_qty) AS c_output FROM traceability t, plt_transact p WHERE t.plt_transact_id = p.plt_transact_id AND t.operation_name='08 C' AND p.plt_no = '$plt_no'";
$resultyield = mysql_query($query);
if($resultyield)
{
if(mysql_num_rows($resultyield) > 0) $c_output = mysql_result($resultyield,0,"c_output");
}
$PLT_yield = @($c_output / $f_output) * 100;
$query = "SELECT SUM(t.input_qty) AS buff_input FROM traceability t, plt_transact p WHERE t.plt_transact_id = p.plt_transact_id AND t.operation_name='09 Buff' AND p.plt_no = '$plt_no'";
$resultyield = mysql_query($query);
if($resultyield)
{
if(mysql_num_rows($resultyield) > 0) $buff_input = $buff_input + mysql_result($resultyield,0,"buff_input");
}
$query = "SELECT SUM(t.output_qty) AS core_output FROM traceability t, plt_transact p WHERE t.plt_transact_id = p.plt_transact_id AND t.operation_name='10 Core' AND p.plt_no = '$plt_no'";
$resultyield = mysql_query($query);
if($resultyield)
{
if(mysql_num_rows($resultyield) > 0) $core_output = $core_output + mysql_result($resultyield,0,"core_output");
}
$query = "SELECT d.operation_name, SUM(d.input_qty) AS inputqty, d.input_unit, SUM(d.output_qty) AS outputqty, d.output_unit FROM traceability d, plt_transact t WHERE t.plt_no = '$plt_no' AND d.plt_transact_id = t.plt_transact_id GROUP BY d.operation_name, d.output_unit, d.input_unit ORDER BY d.operation_name";
$result = mysql_query($query);
if($result)
{
echo "<tr>";
echo "<td><strong>$plt_no</strong></td>";
for($ctr=0; $ctr < $total_row; $ctr++)
{
echo "<td class='tdclass'>";
echo number_format((mysql_result($result,$ctr,"inputqty")),2);
echo "</td>";
echo "<td class='tdclass'>";
echo number_format((mysql_result($result,$ctr,"outputqty")),2);
echo "</td>";
}
echo "<td class='tdclass'><strong>";
printf ("%01.2f", $PLT_yield);
echo "%</strong></td>";
echo "</tr>";
}
}
}
}
$Batch_yield = @($coreoutput / $buff_input) * 100;
echo "<tr>";
echo "<td style='text-align: right; font-weight: bold; font-family: Arial;' class = 'tdclass' colspan='";
$loopctr = ($total_row * 2) + 2;
echo "$loopctr'>Batch Yield: ";
printf ("%01.2f", $Batch_yield);
echo "<strong>%";
echo "</td>";
echo "</tr>";
echo "</table>";
}