<?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: problem with SQL syntax in jqgrid</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/problem-with-sql-syntax-in-jqgrid</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/problem-with-sql-syntax-in-jqgrid/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>pilem1969 on problem with SQL syntax in jqgrid</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/problem-with-sql-syntax-in-jqgrid#p19459</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/problem-with-sql-syntax-in-jqgrid#p19459</guid>
        	        	<description><![CDATA[<p><strong>Notice</strong>: Undefined index: page in&#160;<strong>C:\wamp\www\nwiseCRM\testGrid.php</strong>&#160;on line&#160;<strong>64</strong></p>
<p><strong>Notice</strong>: Undefined index: rows in&#160;<strong>C:\wamp\www\nwiseCRM\testGrid.php</strong>&#160;on line&#160;<strong>67</strong></p>
<p><strong>Notice</strong>: Undefined index: sidx in&#160;<strong>C:\wamp\www\nwiseCRM\testGrid.php</strong>&#160;on line&#160;<strong>71</strong></p>
<p><strong>Notice</strong>: Undefined index: sord in&#160;<strong>C:\wamp\www\nwiseCRM\testGrid.php</strong>&#160;on line&#160;<strong>74</strong></p>
<p><strong>Notice</strong>: Use of undefined constant grid - assumed &#39;grid&#39; in&#160;<strong>C:\wamp\www\nwiseCRM\testGrid.php</strong>&#160;on line&#160;<strong>83</strong><br />Couldn&#39;t execute query.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#39;&#39; at line 1</p>
</p>
<p>Tried to solve this with SQL syntax.&#160;</p>
<p>mysql_select_db(grid, $db) or die("Error connecting to db.");&#160;</p>
</p>
<p>$result = mysql_query("SELECT COUNT(*) AS count FROM invheader");&#160;</p>
</p>
<p>$result = mysql_query( $SQL ) or die("Couldn&#39;t execute query.".mysql_error());$SQL = "SELECT invid, invdate, amount, tax,total, note FROM invheader ORDER BY $sidx $sord LIMIT $start , $limit";&#160;</p>
</p>
<p>I copied from jqgrid&#39;s files but changed name for db,tablename etc.</p>
</p>
<p>Without php it works well with jqgrid.</p>
</p>
<p>Thanks for help!</p>
</p>
<p>// Pilem1969</p></p>
]]></description>
        	        	<pubDate>Wed, 01 Sep 2010 09:57:32 +0300</pubDate>
        </item>
</channel>
</rss>