如何使具有重复值的列紧贴在一起，而其他值在它们之间留有空间

Question

有人知道如何使相同值的值之间不留空格，而不同值的值后面留空格吗？谢谢

示例

ITEMNO DESC STOCKUNIT
[321B3COT4CP08002500000] [DESC Value] [STOCKUNIT Value]

上方和下方保持靠近。

ITEMNO DESC STOCKUNIT (Same ITEMNO as above but other column value is different)
[321B3COT4CP08002500000] [DESC Value] [STOCKUNIT Value]

上下各留一个空隙。

ITEMNO DESC STOCKUNIT (Different ITEMNO Value from above)
[321B3COT4CP08002500000] [DESC Value] [STOCKUNIT Value]

代码：

$table = "SELECT * FROM [TestDB].[dbo].[ICILOC] INNER JOIN [TestDB].[dbo].[ICITEM] ON [TestDB].[dbo].[ICILOC].[ITEMNO]=[TestDB].[dbo].[ICITEM].[ITEMNO] WHERE [QTYONHAND] <> '0' ORDER BY [ICILOC].[ITEMNO] DESC ";
$RS = odbc_exec($connection, $table);
while (odbc_fetch_row($RS)) {
$ITEMNO = odbc_result($RS, "ITEMNO");
$DESC = odbc_result($RS, "DESC");
$STOCKUNIT = odbc_result($RS, "STOCKUNIT");
$UNITWGT = odbc_result($RS, "UNITWGT");
$LOCATION = odbc_result($RS, "LOCATION");
$QTYONHAND = odbc_result($RS, "QTYONHAND");
$QTYONORDER = odbc_result($RS, "QTYONORDER");
$QTYSALORDR = odbc_result($RS, "QTYSALORDR");
if ($ITEMNO = $ITEMNO) {
echo "<br>";
} 
echo "<center><table>";
echo "<th><center>ITEMNO</center></th>";
echo "<th><center>DESC</center></th>";
echo "<th><center>STOCKUNIT</center></th></tr>";
echo "<tr><td>$ITEMNO</td>";
echo "<td>$DESC</td>";
echo "<td>$STOCKUNIT</td></table>";
echo "<center><table><tr>";
echo "<center><th><center>LOCATION</center></th>";
echo "<th><center>QTYONHAND</center></th>";
echo "<th><center>QTYONORDER</center></th>";
echo "<th><center>QTYSALORDR</center></th>";
echo "<tr><td>$LOCATION</td>";
echo "<td>$QTYONHAND</td>";
echo "<td>$QTYONORDER</td>";
echo "<td>$QTYSALORDR</td></tr>";
}
echo "</table>";
odbc_close($connection);

Answer 1

您可以生成if语句，如果不相同，则插入一个中断

$table = "SELECT * FROM [TestDB].[dbo].[ICILOC] INNER JOIN [TestDB].[dbo].[ICITEM] ON [TestDB].[dbo].[ICILOC].[ITEMNO]=[TestDB].[dbo].[ICITEM].[ITEMNO] WHERE [QTYONHAND] <> '0' ORDER BY [ICILOC].[ITEMNO] DESC ";
$RS = odbc_exec($connection, $table);
while (odbc_fetch_row($RS)) {
if ($ITEMNO != odbc_result($RS, "ITEMNO")) {
echo "<br><br>";
} 
$ITEMNO = odbc_result($RS, "ITEMNO");
$DESC = odbc_result($RS, "DESC");
$STOCKUNIT = odbc_result($RS, "STOCKUNIT");
$UNITWGT = odbc_result($RS, "UNITWGT");
$LOCATION = odbc_result($RS, "LOCATION");
$QTYONHAND = odbc_result($RS, "QTYONHAND");
$QTYONORDER = odbc_result($RS, "QTYONORDER");
$QTYSALORDR = odbc_result($RS, "QTYSALORDR");

echo "<center><table>";
echo "<th><center>ITEMNO</center></th>";
echo "<th><center>DESC</center></th>";
echo "<th><center>STOCKUNIT</center></th></tr>";
echo "<tr><td>$ITEMNO</td>";
echo "<td>$DESC</td>";
echo "<td>$STOCKUNIT</td></table>";

echo "<center><table><tr>";
echo "<center><th><center>LOCATION</center></th>";
echo "<th><center>QTYONHAND</center></th>";
echo "<th><center>QTYONORDER</center></th>";
echo "<th><center>QTYSALORDR</center></th>";

echo "<tr><td>$LOCATION</td>";
echo "<td>$QTYONHAND</td>";
echo "<td>$QTYONORDER</td>";
echo "<td>$QTYSALORDR</td></tr>";
}


echo "</table>";
odbc_close($connection);