<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: mysql_query breaks on remote server</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/mysql_query-breaks-on-remote-server</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/mysql_query-breaks-on-remote-server/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>dancombs on mysql_query breaks on remote server</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/mysql_query-breaks-on-remote-server#p26938</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/mysql_query-breaks-on-remote-server#p26938</guid>
        	        	<description><![CDATA[<p>I have 3 jqGrids on a php page that are interacting with one another. I am using WAMPServer to provide the apache, php, and mySQL for testing the php on localhost.</p>
<p>In localhost, my php pages work perfectly, all 3 jqGrids are populated. When I put my php files on my website, the jqGrids remain empty. Using Firebug on Firefox, I have narrowed down the problem to here:</p>
<p style="padding-left: 30px;">$isic = $_GET[&#39;isic&#39;]; <span style="color: #ff0000;">//This is the value being passed to this php page</span><span style="color: #ff0000;">, it works</span></p>
<p style="padding-left: 30px;">$result = mysql_query(&#39;SELECT COUNT(*) AS count FROM command WHERE ISIC = &#39; . $isic); <span style="color: #ff0000;">// $result remains empty</span></p>
<p style="padding-left: 30px;">$row = mysql_fetch_array($result,MYSQL_ASSOC);&#160; <span style="color: #ff0000;">// $row remains empty</span></p>
<p style="padding-left: 30px;">$count = $row[&#39;count&#39;]; <span style="color: #ff0000;">//$count remains empty<br /></span></p>
<p>My webhost is using PHP 5.2.11 and MySQL 5.0.91. I&#39;ve set WAMPServer to reflect PHP 5.2.9-2 and MySQL 5.0.88. Like I said earlier, this works for locahost. If I paste the select statement into mysqladmin like:</p>
<p style="padding-left: 30px;">SELECT COUNT(  *  )  AS count FROM command WHERE ISIC = &#39;39791&#39;;</p>
<p>I get a count of 5 which is as it should be. I&#39;m thinking the problem might be with my isp but am not sure.<img class="spSmiley" style="margin:0" title="Cry" src="/blog/wp-content/forum-smileys/sf-cry.gif" alt="Cry" /></p>
]]></description>
        	        	<pubDate>Wed, 11 Jul 2012 20:14:25 +0300</pubDate>
        </item>
</channel>
</rss>