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
