Hi i got error
recoverable fatal error: Object of class mysqli_result could not be converted to string in F:\wamp\www\vijaishopping\themes\garland\block.tpl.php on line 10.
Hi i tried custom module, it through the error ,
What i do now,
my snippet below
<?php
function alphabeticalsearch_block($op = 'list', $delta = 0, $edit = array()){
if($op == "list") { $block = array(); $block[0]["info"] = t('Alphabetical Search'); return $block; } elseif($op == 'view'){ $alphabetical_search_result = db_query("SELECT node.nid AS nid, node.title AS node_title, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid where node.title like '%a'");
$block['subject'] = 'Click to send request'; $block['content'] = $alphabetical_search_result; return $block; }
}