Report only displays first row of results
Posted: Mon Feb 17, 2014 9:10 pm
I haven't been using NuBuilder for long and have just started experimenting with reports.
Created a very simple table with 4 columns (id, red, blue, yellow) and 4 rows of numbers
Here is the PHP Data Code from the Report tab
$s = "CREATE TABLE #dataTable# SELECT * from test ";
nuRunQuery($s);
When I run the SQL in PhpMyAdmin it returns 4 rows as expected but the report returns the first row only.
Any help appreciated
thanks
Created a very simple table with 4 columns (id, red, blue, yellow) and 4 rows of numbers
Here is the PHP Data Code from the Report tab
$s = "CREATE TABLE #dataTable# SELECT * from test ";
nuRunQuery($s);
When I run the SQL in PhpMyAdmin it returns 4 rows as expected but the report returns the first row only.
Any help appreciated
thanks