php和mysql的查询限制问题（drupal 6） [英] query limit issue with php and mysql (drupal 6)

问题描述

我试图在drupal中进行查询，该查询选择了表中的每一行，但我遇到了行数不存在的问题，我能够查询该查询的行数限制为300行，但如果我将其增加到400行，

hi i was trying to do a query in drupal which selects every row in table, i was having an issue with the no of rows i was able to query for the query is working for 300row limit but if i increase it 400 it is going blank page.

$total_terms = 300;
$query = "SELECT N.nid ,N.tid FROM term_node N  ";
$query_result = db_query_range($query, $vid, 0, $total_terms);

推荐答案

您可能是定时，或超出您的内存限制。检查Apache和PHP日志。

You are probably timing out, or exceeding your memory limit. Check the Apache and PHP logs.

这篇关于php和mysql的查询限制问题（drupal 6）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！