我想写一个SQL查询来查找节点ID（nid），该节点的标题与给定内容类型的给定标题（标题字段值的值）相匹配。我正在尝试以下操作-
function title_ajax_check_duplicate($title, $type) {
$results = db_query("SELECT nid FROM {node} WHERE title = %s AND type = %s ", $title, $type);
if (!empty($results)) {
// This is a duplicate.
return $results;
}
else {
return FALSE;
}
}
I am not able to solve this for a long time. Any help would be much appriciated. Thanks in advance.
$results将返回一个mysql资源，而不管实际结果如何。
签出db_fetch_array这实际上会包含结果。然后，您必须迭代结果数组才能找到重复的结果。
将查询行更改为：
$result=db_result（db_query（“SELECT nid FROM｛node｝WHERE title=%s AND type=%s”，$title，$type）
I am working on a custom module with multi-page form on drupal 6. I found that #default_value is not working when my #type => textfield . However, when #type => textarea , it displays correctly ...
I have a created a view (lets call it my_view). In the theme: information section if the view I have noted one of the suggested template names (views-view--my-view--default.tpl.php (or close to that))...
Which is the best module for Syntax Highligting in Drupal. I am using GeSHi for syntax highlighting my code. It was working fine then I installed a second module FCKeditor. Now GeSHi filter is not ...
I have two content types, book and chapter. Each chapter node contains a node reference of the book to which it belongs. I have created a view which displays the title of each chapter for a given ...
I m not quite sure how to do this in SQL. Here it is in pseudocode: Take the list of nodes with content type X. For each node, take the value of field Y. Insert into term_nodes VALUES ((tid that ...
Although I am using drupal since the D4 series, I only started developing professionally for it with D6, so - despite I did various site upgrades - I was never faced by the task of having to port my ...
I need to limit access of content on Drupal site based on the Drupal User s Role. http://site.com/managers/intro http://site.com/managers/reviews http://site.com/managers/up-for-raises The ...
I am using Drupal 6.x with Zen theme. Currently, the following 3 user functions are grouped under a menu, when accessing urls like http://domain.com/user Create new account / Log in / Request ...