print mysql query to template

[daddy6745]

is it possible to take query results and print them to a template page without viewing the webpage for each record? I need to print 100's of records at once using the same output page but how do I do this?

[devinemke]

do you mean simply displaying multiple records on a single page or writing the data from multiple records to multiple text files?

[daddy6745]

i need to take multiple records and print them individually on one "template" page.

[daddy6745]

i also need to print the reports at the same time. Autogenterate printing all records by clicking one button.

[devinemke]

put a string in the template where you want the query result to go (like [query results]) and then do:

$result = mysql_query('SELECT * FROM table');
$output = '';
while ($row = mysql_fetch_assoc($result))
{
	$output .= print_r($row);
}

$template = file_get_contents('/path/to/template');
$template = str_replace('[query results]', $output, $template);
echo $template;

[daddy6745]

I already have the template populating, what I need is a way to print each page once its populated with a record so it will print all the records in the query. For example if I have 100 records I want to print 100 pages.