Smarty

see your previous post

The query would be quicker if you did a join rather than a subselect:

function GetData($table1,$table2,$table3,$id) {
$sql = "SELECT h.id, h.title, h.head_type, h.head_code, ...

The following appears to give the correct total:

{foreach from=$obj->mItems item="item"}
{math assign="total" equation="x + y" x=$total|default&# ...

If you are printing this out in html you can use the nl2br modifyer to convert all linebreaks to <br />, hope this helps:

example:

{$MyText|nl2br}

The if statements appear to be nested funny... then again i cant see entire code so.
Your code:

{if $dept eq "Maps"}{else}><a HREF="person_details.php?Id={$ID}&Dept={$dep ...

You could use the file_exists modifier to check to see if the file exists, just make sure you use the absolute path ie: _images/test.jpg no leading forward slash:

{if $id|cat:'.jpg'|file ...

Based on your queries you do not have a unique identifier tying the news to the user in your array. I would recommend doing a LEFT JOIN on your sql query to return all news items and the user info wh ...

You need to assign a name to your section loop and use that when comparing the index or iteration in this case 'allseats':

{section start=1 loop=$seats+1 step=1 name=allseats}
...

Please provide some code so that you can be assisted. It depends on how your array and loops are setup.

if you are just going to name them based on the iteration : 1,2,3,4,5,etc...

{* Extra Fields *}
{foreach from=$extrafields item=extras name=myextras}
<tr class="ex ...

Not sure exactly how your code works, but rather than try to include a WHERE clause could you use it in the IF statement?

{if $page_name == 'category' && $id_cat_bg->id_parent|int ...

Why not use the style inside the tag just for the background?

TPL:

<div id="contenu" style="background:url({$link->getCatImageLink($category->link_rewri ...

have you passed (assigned) these values to the template? if so in the template use the foreach loop.

smarty:

{foreach from=$array key=k item=i}
<div id="{$i.user_id ...

scuzzy is correct. you want to layout your templates accordingly. If you want a header template, you should also have a footer template. layout your 3 "body" templates in floating div's. ...

Okay, so obviously you will need to clean up the fields, where you did not provide them all. This is not tested, and am not sure if this is what you are looking for but...

PHP:

$sql = "SEL ...