MySQL,查询计数结果并显示在PHP页面中 [英] MySQL, Query count results and display in PHP page
问题描述
我有下面的查询。我需要计算返回多少项/行,然后在运行此查询的PHP页面上显示该数字。
I have the below query. I need to count how many items/rows are returned and then display that number on the PHP page this query is run from.
$query1 = "
SELECT HD_TICKET.ID as ID,
HD_TICKET.TITLE as Title,
HD_STATUS.NAME AS Status,
HD_PRIORITY.NAME AS Priority,
HD_TICKET.CREATED as Created,
HD_TICKET.MODIFIED as Modified,
HD_TICKET.CUSTOM_FIELD_VALUE10 as SLA,
S.FULL_NAME as Submitter,
O.FULL_NAME as Owner,
HD_TICKET.CUSTOM_FIELD_VALUE0 as Type
FROM HD_TICKET
JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID)
JOIN HD_PRIORITY ON (HD_PRIORITY.ID = HD_TICKET.HD_PRIORITY_ID)
LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID)
LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID)
WHERE (HD_TICKET.HD_QUEUE_ID = $mainQueueID) AND
(HD_STATUS.NAME like '%Open%')
ORDER BY ID DESC
";
这可能吗,我不是MySQL友好的。基本上如果我可以输出计数,我可以把它拉进一个表格,让我用PHP / HTML / CSS刷新它。
Is this possible, I am not MySQL friendly. Basically if I can output the count number I can then pull that into a table for me to flash it up with PHP / HTML / CSS.
我提前感谢任何帮助谢谢你的时间。
I appreciate any help in advance thanks for your time.
推荐答案
如果您使用的是 mysql
扩展,您可以使用 mysql_num_rows()
获取结果中的行数。
If you're using the mysql
extension, you can get the number of rows in the result with mysql_num_rows()
.
$row_count = mysql_num_rows($result1);
echo "There are $row_count results</b>";
while ($row = mysql_fetch_assoc($result1) {
// Display row of results
}
如果您不想显示结果,则应简化查询。您不必指定要返回的列,也不需要订购结果。
If you don't want to display the results, you should simplify your query. You don't have to specify the columns to return, and you don't need to order the results.
$query = "SELECT COUNT(*) as cnt
FROM HD_TICKET
JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID)
JOIN HD_PRIORITY ON (HD_PRIORITY.ID = HD_TICKET.HD_PRIORITY_ID)
LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID)
LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID)
WHERE (HD_TICKET.HD_QUEUE_ID = $mainQueueID) AND
(HD_STATUS.NAME like '%Open%')";
$result1 = mysql_query($query);
$row = mysql_fetch_assoc($result1);
$row_count = $row['cnt'];
echo "$row_count results";
这篇关于MySQL,查询计数结果并显示在PHP页面中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!