Connecting to MySQL database?

[DJ RRebel]

I think I know what you're getting at ... but how would I go abouts doing that?

I'm fairly confident I know how to create a template (done it a couple of years ago). But how would I go abouts calling the template from the php file?

Let's say I have a file getfunkydata.php

In that file, I would have to have:

require_once(global.php);

then:

- Call a master template that starts the introduction of the page and the start of a table where my results will be placed, as well as calls the header/footer templates. Then:

$query_results = mysql_query("SELECT column_a, column_b, column_c FROM table_xyz;");

- Start a loop for 0 to mysql_num_rows($query_results). Then within the loop have


$rowdata = mysql_fetch_array($query_results);

$col_a = htmlspecialchars(stripslashes($rowdata("column_a") );
$col_b = htmlspecialchars(stripslashes($rowdata("column_b") );
$col_c = htmlspecialchars(stripslashes($rowdata("column_c") );

- A call to a row formating template (that I'll have to create) which would include:
<tr><td>$col_a</td><td>$col_b</td><td>$col_c</td></tr>




I'm not too sure how the php page interacts with or call the templates?

seems to me, the looping data is linked from the templates in several "_bits" sub-templates, but I'm not sure how that is controled via the php page?


Anyhow .. you guys are REALLY helpful ... I think I'm actually starting to see the light at the end of the tunnel here !!!