in setting .php i changed ,<br><br>mysqli to mysql , <br><br><br>now prob fixeds,<br><br>thanks<br><br><div class="gmail_quote">On Mon, Feb 15, 2010 at 12:19 AM, Buddhika Laknath <span dir="ltr"><<a href="mailto:blaknath@gmail.com">blaknath@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">This is because of this line of code.<br>
<div class="im"><br>
$block['content'] = $alphabetical_search_result;<br>
<br>
</div>Where your $alphabetical_search_result is a mysql result resource object<br>
and Drupal expects instead a string.<br>
<br>
Change the above line to something like this.<br>
<br>
<br>
while ($line = db_fetch_object($alphabetical_search_result){<br>
$block['content'] += $line->some_text_feild_in_database;<br>
}<br>
<br>
-Laknath<br>
<div><div></div><div class="h5"><br>
bharani kumar wrote:<br>
><br>
><br>
> Hi i got error<br>
><br>
> recoverable fatal error: Object of class mysqli_result could not be<br>
> converted to string in<br>
> F:\wamp\www\vijaishopping\themes\garland\block.tpl.php on line 10.<br>
><br>
><br>
> Hi i tried custom module, it through the error ,<br>
><br>
> What i do now,<br>
><br>
> my snippet below<br>
><br>
> <?php<br>
><br>
> function alphabeticalsearch_block($op = 'list', $delta = 0, $edit =<br>
> array()){<br>
><br>
> if($op == "list") {<br>
> $block = array();<br>
> $block[0]["info"] = t('Alphabetical Search');<br>
> return $block;<br>
> }<br>
> elseif($op == 'view'){<br>
> $alphabetical_search_result = db_query("SELECT node.nid AS nid,<br>
> node.title AS node_title, node_revisions.body AS node_revisions_body,<br>
> node_revisions.format AS node_revisions_format FROM node<br>
> node LEFT JOIN node_revisions node_revisions<br>
> ON node.vid = node_revisions.vid where node.title<br>
> like '%a'");<br>
><br>
> $block['subject'] = 'Click to send request';<br>
> $block['content'] = $alphabetical_search_result;<br>
> return $block;<br>
> }<br>
><br>
> }<br>
><br>
><br>
<br>
<br>
</div></div>--<br>
I blog at <a href="http://mytechgossips.com" target="_blank">http://mytechgossips.com</a><br>
<font color="#888888"><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Regards<br>B.S.Bharanikumar<br><a href="http://php-mysql-jquery.blogspot.com/">http://php-mysql-jquery.blogspot.com/</a><br>