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
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Report only displays first row of results
-
- Site Admin
- Posts: 2786
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 3 times
Re: Report only displays first row of results
need2know,
Could it be that your fields are in a group section?
Steven
Could it be that your fields are in a group section?
Steven
-
- Posts: 2
- Joined: Thu Dec 05, 2013 9:08 pm
Re: Report only displays first row of results
I deleted that report and recreated it and it worked this time. Must have done something wrong
thanks
thanks