Bogdan, Thank you for your comment, it actually made me think of a possible solution for something else I am working on. However, it is just as I thought, I am being too vague. I am most likely making my whole situation more complicated than I need. Another idea is just to do a "select *" and run the whole shebang through an IF/ELSE series to determine which headers are being used. However, to remain on my current train of thought, here is a snippet of my code:
include("inc/dbconnect.inc"); $sql = "select columns from tablename where id=$someid"; $sqlresult = mysql_query($sql, $connection) or die("Couldn't execute query. (7)"); $columns_array = explode(",", $sqlresults['columns']); while (list($col) = each($columns_array)) { $sql = "select coltitle from FreudColumns where colid='$col'"; $result = mysql_query($sql, $connection) or die("Couldn't execute query. (12)"); $ch = mysql_fetch_array($result); // Set the column headers $headers .= "<TH CLASS=\"hlink\">$ch['coltitle']</TH>"; // Set the item variables $setitemvar .= "\$$col = \$isr['$col'];"; // Set the measurement columns $setitem .= "<TD CLASS=\"\$itemclass\">\$$col</TD>"; } Afterwhich I write $headers to a file, $setitemvar to a file, $setitem to a file and call the page that is supposed to include these files I have just writed so that the PHP code that I have just dynamically written will then execute and the variables will be replaced. Does this make any more sense? Thank you, Jonathan Duncan "Bogdan Stancescu" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I don't quite understand why you chose such a complicated solution - I > may be missing something, in which case sorry for wasting your time. But > why don't you just dynamically build the select statement and then use > the <whatever>_fetch_array() -- and walk that array instead? > > Just my 2c > > Bogdan > > Jonathan Duncan wrote: > > >I am trying to figure out a way to dynamically create some lines of PHP code > >and then have it executed. This is because I want a page to display > >different columns in a table depending on whatever link is clicked. There > >are hundreds of different combinations of column headings so I don't want to > >make a different PHP page that is formated for each different combination. > >The column headings are stored in a database. > > > >So far what I have come up with is to have a starting page, that takes the > >value of the link that is clicked, it queries the database for that value > >and then does a while statement to make all the <TD>'s for the different > >columns. Each <TD> is populated with a different variable, one for each > >column header. Each iteration I append to a variable to hold all of these > ><TD>'s. Then I write the contents of that variable to a temporary include > >file and call the page that will display the table. That table then > >includes those <TD>'s from the include file I wrote them to and executes the > >PHP that runs another query on the database and fills in the variables in > >those <TD>'s. > > > >This seems like a lot of work. Does what I am trying to do make sense to > >anyone? Does anyone have any idea how to do this an easier way? > > > >Thanks > >Jonathan Duncan > > > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php