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:

  $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.
 $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
> 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
> >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.
> >are hundreds of different combinations of column headings so I don't want
> >make a different PHP page that is formated for each different
> >The column headings are stored in a database.
> >
> >So far what I have come up with is to have a starting page, that takes
> >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
> ><TD>'s.  Then I write the contents of that variable to a temporary
> >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
> >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 (
To unsubscribe, visit:

Reply via email to