Simple Machines Community Forum

Customizing SMF => SMF Coding Discussion => Topic started by: dixer on December 17, 2012, 11:05:40 AM

Title: In search of... code to display a simple sql query
Post by: dixer on December 17, 2012, 11:05:40 AM
I have a few simple queries I want to display.  Some will be restricted to user attributes via the Where clause, but I can handle the parameters myself.  The unknown part for me is formatting the results.

So I'm asking for raw code (or a pointer to a very simple mod) which gives an example of issuing a query and displaying its results as a table.  I know the column names, so I'm not looking for anything fancy like pulling column names from the schema or query text.  Simple for you and simple for me, I hope.

Yes, I searched first, but couldn't find a simple example.  Thank you in advance.
Cheers
Title: Re: In search of... code to display a simple sql query
Post by: IchBin™ on December 18, 2012, 03:05:12 PM
There are several functions in the SSI.php file that do this.
Title: Re: In search of... code to display a simple sql query
Post by: dixer on December 21, 2012, 07:26:58 AM
Thank you.  From there I can mix and match what I need.