server-side "no fields entered null" error
server-side "no fields entered null" error
kathys2151
Posts: 5Questions: 2Answers: 0
http://jsfiddle.net/kathys2151/7zpe21db/
I've got a jsFiddle with most of the code in there (can't run it because no db). Basically in index.html the user fills out a form with what he wants to search on. That data is serialized and passed to search_processing, which does the mysql query and gets the data. (This is working as I can see the mysql query is succeeding and is formed correctly). In my Firebug console the json being returned from my search_processing.php is correct:
js
{ "draw": 0, "recordsTotal": "46555", "recordsFiltered": "2", "data": [{"company":"abc", "street":"123 Main Street".....
The class.ssp file is exactly the same as the docs, and I return an array as show in the jsFiddle.
I write out "success" to the console, and search_display.php is called to populate the dataTables with the results of the search. This is where I get the "No Fields entered response" and a datatables error of "Uncorrectly formed JSON".
What am I doing wrong?