Database output Problems

Getting output from one table to another

[theJoekr]

Ok first i'll explain what i have exactly.

A website in PHP, with attached to it a mysql database.
I didn't create the website so i have some trouble with getting this problem fixed.
In the bottom of my page there are some standard links, like: About, Privacy and Links.

Well the problem is with the Links link/page.

The creater of the website made it so that those links open a page that is retrieved from a field in a table in the database (pages). I can't change that. Now i wanted to create the "Links" page wich he didn't or threw away. The page is supposed to be a page filled with link exchanges and should exsist of multiple pages.

Now i tried offcourse to create it and then putting it into the database but offcourse it doesn't work since a database can't read PHP. so i think i have no choice but to do it in HTML, right? But that's not the only thing. Since it's gonna be over 100 links, and i need to change them every once and a while and be able to easily delete/add them. so it was my thought to make a table in a database and use that.

Now my question is what is the best choice in what to make, and second how do i realize that?

[theriddla1019]

I have built a report form that every single piece of the reports are put into a mysql database. To do this all I did was simply put the exact code as it would appear in php into a longtext field in the database. Then I set the title of the report in a field and select the components by that title. Using the information i selected the fields i wanted from the matching title and did this:

"SELECT $report_fields FROM
$report_tables
$WHERECLAUSE
$report_groupby
$HAVING
$ORDERBY";

each one of the variables is just a field in the db
not sure if this is what your lookin for