Greetings
Looking for tips on displaying the result of a mysql view where the number of records returned can vary. I can use echo and do the field by field but I have a membership list and need to display the names of all the selected members and they keep growing.
Displaying results from a result set using PHP
Re: Displaying results from a result set using PHP
Figured it out. Construct the final string in PHP and the <br>
Use a textbox with the "Do not encode HTML characters," enabled.
in the textbox simply add the <?php echo $constructed_string;?>
Give it enough room to grow and you can show table data.
Use a textbox with the "Do not encode HTML characters," enabled.
in the textbox simply add the <?php echo $constructed_string;?>
Give it enough room to grow and you can show table data.
Re: Displaying results from a result set using PHP
Or you could use the Dataviewer extension - or the Responsive Data Table (paid for) extension. For a membership list it is also possible to get the output in alphabetical order if your MySQL table have been set up with a "lastname" field, by using the filter in the extension and inserting "lastname IS NOT NULL ORDER BY lastname".
Re: Displaying results from a result set using PHP
Thanks!!! I just saw that extension. Appreciate it. Do you have link for the Data Table?
- BaconFries
-
- Posts: 5936
- Joined: Thu Aug 16, 2007 7:32 pm
Re: Displaying results from a result set using PHP
This is great! Love the layouts in the mobile breakpoints.