<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[PunBB Forums — Unexpected Query Results]]></title>
		<link>https://punbb.informer.com/forums/topic/23878/unexpected-query-results/</link>
		<atom:link href="https://punbb.informer.com/forums/feed/rss/topic/23878/" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Unexpected Query Results.]]></description>
		<lastBuildDate>Mon, 31 Jan 2011 17:37:56 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Unexpected Query Results]]></title>
			<link>https://punbb.informer.com/forums/post/139134/#p139134</link>
			<description><![CDATA[<p>Took a while, but I figured it out, so n/m.&nbsp; There aren&#039;t very many people on this forum, are there?&nbsp; &nbsp;Shame...</p>]]></description>
			<author><![CDATA[null@example.com (Warhaven)]]></author>
			<pubDate>Mon, 31 Jan 2011 17:37:56 +0000</pubDate>
			<guid>https://punbb.informer.com/forums/post/139134/#p139134</guid>
		</item>
		<item>
			<title><![CDATA[Unexpected Query Results]]></title>
			<link>https://punbb.informer.com/forums/post/139109/#p139109</link>
			<description><![CDATA[<p>Hey All,</p><p>I&#039;m working on an extension that adds dice rolling and validation functionality for the numerous play-by-post games run on my forum.&nbsp; My original code was embedded in PunBB 1.2.x, and so I&#039;ve been in the process of porting it to the newer (and OMG, much nicer...) extension format.</p><p>Anyway, I&#039;m getting erroneous results from my query, and I&#039;m not sure why.&nbsp; The query:</p><div class="codebox"><pre><code>$query = array(
                &#039;SELECT&#039;    =&gt; &#039;rolls&#039;,
                &#039;FROM&#039;        =&gt; &#039;dice_rolls&#039;,
                &#039;WHERE&#039;        =&gt; &#039;id=&#039;.$pid.&#039; AND topic_id=&#039;.$id.&#039; AND top=1&#039;
            );
            
            $result = $forum_db-&gt;query_build($query) or error(__FILE__, __LINE__);</code></pre></div><p>The result I&#039;m getting is, &quot;Resource id #&lt;some number&gt;&quot; instead of the expected values from the `rolls` field.</p>]]></description>
			<author><![CDATA[null@example.com (Warhaven)]]></author>
			<pubDate>Fri, 21 Jan 2011 18:18:33 +0000</pubDate>
			<guid>https://punbb.informer.com/forums/post/139109/#p139109</guid>
		</item>
	</channel>
</rss>
