test1.php
CODE
$dbhost = 'localhost';
$dbuser = '---------';
$dbpass = '--------------';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die
('Nie można połączyć się z bazą.');
$dbname = '------------';
mysql_select_db($dbname);
$sql="SELECT SUM( dl ) as il FROM pliki";
$query=mysql_query($sql);
$row =mysql_fetch_array($query);
$query2 = mysql_query('select count(*) from pliki');
$query_r = mysql_fetch_row($query2);
$count = $query_r[0];
$pob= $row['il'];
//echo $pob;
//echo $count + 2000;
?>
oraz
test1.tpl
CODE
W1:{$pob}
W2:{$count}
W2:{$count}
</div>
I trzci plik z tpl menu:
left.tpl
<div style="margin-top:5px">
<table border="0" cellspacing="0" cellpadding="0" width="188" bgcolor="ffffff">
<tr height="9">
<td width="11">{html_image file="/g/lmtl.jpg"}</td>
<td width="166" background="/g/lmtc.jpg">{html_image file="/g/lmtc.jpg"}</td>
<td width="11">{html_image file="/g/lmtr.jpg"}</td>
</tr>
<tr>
<td width="11" background="/g/lmlb.jpg"><img src="/g/clear.gif" widht="1" height="1" /></td>
<td width="166">
<p align="center">{include file="test1.tpl"}</p>
</td>
<td width="11" background="/g/lmrb.jpg"><img src="/g/clear.gif" widht="1" height="1" /></td>
</tr>
<tr>
<td width="11">{html_image file="/g/lmbl.jpg"}</td>
<td width="166" background="/g/lmsc.jpg">{html_image file="/g/lmsc.jpg"}</td>
<td width="11">{html_image file="/g/lmbr.jpg"}</td>
</tr>
</table>
</div>
Nie wiem dlaczego, ale nie wczytuje mi danych z bazy. Może macie jakieś rozwiązanie.