我必须使此代码返回相同的结果,但仅在用户ID为数字的情况下(ex 16);每个设备在此表中都有一个用户ID和用户名。这是代码:
<?php
$myQuery= 'SELECT * FROM devicesissued di LEFT JOIN usercred uc ON di.userID = uc.userID WHERE 1 ORDER BY timeStamp DESC';
$result = mysql_query($myQuery) or die($myQuery."<br/><br/>".mysql_error());
while($row = mysql_fetch_array($result))
{
$catQuery = 'SELECT * FROM deviceinventory WHERE deviceID = '. $row['deviceID'];
$catResult = mysql_query($catQuery) or die($catQuery."<br/><br/>".mysql_error());
$cat = mysql_fetch_array($catResult);
echo "<tr>";
echo "<td>" . $row['displayName'] . "</td>";
echo "<td>" . $row['deviceID'] . "</td>";
echo "<td>" . $cat['barCodeID'] . "</td>";
echo "<td>" . $cat['category'] . "</td>";
echo "<td>" . $row['deviceName'] . "</td>";
echo "<td>" . $cat['operatingSystem'] . "</td>";
echo "<td>" . $cat['serialNumber'] . "</td>";
echo "<td>" . $cat['macAddress'] . "</td>";
echo "<td>" . $row['timeStamp'] . "</td>";
echo "</tr>";
}
?>
如果我添加WHERE 'userID' = A-Number
子句,它无能为力。
如果您有任何想法,我会很乐意尝试它们。
谢谢。
尝试更改查询一点
$myQuery= 'SELECT * FROM devicesissued di
LEFT JOIN usercred uc ON di.userID = uc.userID
WHERE di.userID=the_number_here ORDER BY timeStamp DESC';
当您在两个连接表中都有UserId(deviceissued
和usercred
),您必须告诉MySQL您要执行哪个表格WHERE
-CPRAUSE。