I'm looking to create a special report within a static page that would query specific information from a database. Has anyone done this previously and have any sample code?

Any information that you may be able to provide would be greatly appreciated, thanks!

Normal PHP Code:



That is the code to connect to a database. Put in your "database_name", username and password.

Now use SQL queries to get info from the database. Refer to PHP/MYSQL Manuals for more info.

there are many phpblocks hanging around that will serve you as perfect guidelines. check the downloads section here and I think the faq has some links to where you can get stuff for geeklog like blocks, etc. Most of the geeklog code itself has tons of database query stuff that will guide your efforts.

DON'T use your db username and password in the phpblock. there is no need to connect to the db or disconnect or anything like that. if you are using the phpblock within the confines of your geeklog pages, that is all taken care of for you.

so all you need is a quick and easy to read tutorial on how to use the "SELECT" query for mySQL.
once you've selected your data, loop thru your result set and display/echo the data using basic HTML. done

So, if I shouldn't use the db username and password in phpblock, could someone give me (or point me to samples) of how to connect to the GL database, how to pull data out, and how to display it. I'm familiar with SQL, so I'll be fine concocting the statements to pull the data out... I just need some sample code to get me going... you know, something along the lines of "Hello world!"...

using geeklog syntax/db functions
perhaps the mysql manual would tell you what you want to know...