[SOLVED]Execute a query with the output of another
Posted: Mon Apr 05, 2004 1:55 am
Hi there,
i hope my subject header is not too confusing; what i mean is the following:
I have a script (almost a template) which grabs content (images, text, references a.s.o.) denpending on the passed parameters (company, department, chapter, page number, stanza ...) out of a database; the script is used for every department in the comapny and it is working well.
The problem is that i have to execute sub-queries (for example, to provide additional information about how many people are working in Department 1 - to be displayed in chapter 2, page 3, stanza 11) after the main query.
Is it possible to enter a query code into a DB table and to print or echo it out into a script AND to execute it there?
P.S.: To the moderators: Please don't be
if this post belongs to another forum.
Thanx in advance for help,
- bluenote
i hope my subject header is not too confusing; what i mean is the following:
I have a script (almost a template) which grabs content (images, text, references a.s.o.) denpending on the passed parameters (company, department, chapter, page number, stanza ...) out of a database; the script is used for every department in the comapny and it is working well.
The problem is that i have to execute sub-queries (for example, to provide additional information about how many people are working in Department 1 - to be displayed in chapter 2, page 3, stanza 11) after the main query.
Is it possible to enter a query code into a DB table and to print or echo it out into a script AND to execute it there?
P.S.: To the moderators: Please don't be
Thanx in advance for help,
- bluenote