需要数据库中的数据而不是资源ID - Need data from DB instead of resource ID

Need data from DB instead of resource ID

本文关键字：资源 ID 数据数据库 | 更新日期: 2023-09-27

我已经使用stackoverflow.com回答问题一段时间了，但这是我第一次发帖。提前感谢！

我正在尝试获取与此查询相关联的实际号码：

$purchasenumber = mysql_query("SELECT `purchase_order_number` FROM `purchaseorder` ORDER BY `purchase_order_number` DESC LIMIT 1");
echo $purchasenumber;

我收到的是一个"资源id#"，而不是实际数字。

然后，我想使用检索到的数字从数据库中提取更多数据。我实际上是在用数据库中的两个表中的信息创建一个可打印的页面。

$result = mysql_query("SELECT * FROM purchaseorder, customers WHERE purchase_order_number = $purchasenumber AND purchaseorder.customer_ID = customers.customer_ID");
while ($row = mysql_fetch_assoc($result)) {}

有人想把资源id转换成实际数据吗？我可能走错了路，如果我是，请告诉我！

谢谢。

您需要使用mysql_fetch_array（）从mysql_query:中获取数据

    $result = mysql_query("SELECT `purchase_order_number` FROM `purchaseorder` ORDER BY `purchase_order_number` DESC LIMIT 1");
    $data = mysql_fetch_array($result);
    $purchasenumber = $data['purchase_order_number'];

更多信息可在PHP.net 上找到

谢谢，kimbarcelona。你的回应奏效了。

$result = mysql_query("SELECT `purchase_order_number` FROM `purchaseorder` ORDER BY `purchase_order_number` DESC LIMIT 1");
$data = mysql_fetch_array($result);
$purchasenumber = $data['purchase_order_number'];

然后我只是为下一个结果使用了一个不同的变量

$result2 = mysql_query("SELECT * FROM purchaseorder, customers WHERE purchase_order_number = $purchasenumber AND purchaseorder.customer_ID = customers.customer_ID");
while ($row = mysql_fetch_assoc($result2)) {}

再次感谢您的回复！