[Smarty][MySQL][PHP] Rysowanie tabelki (krzyżowej?) Opcje

[kasior]

Pomózcie proszę, bo juz sie zakręciłem zupełnie. Mam dane, ale z rysowaniem tego juz problem.
Ale po kolei. Są dwie tabele: drivers i graph. W pierwszej sa kierowcy, w drugiej sa zapisywane dane ich statusów w poszczególnym tygodniu (np "w aucie")

Wygląda to tak:

(IMG:http://peterwebs.pl/tabela.jpg)

Jedynki sa wpisane tylko na razie,zeby coś było widać.

Najpierw wyciągam z bazy dane:

[PHP] pobierz, plaintext 
$sql= 'select * from drivers where active = "1"';
$stmt = $hDB->prepare($sql);
$stmt->execute();
$num = $stmt->rowCount();
 
 
	if ($num>0){
	$art = $stmt->setFetchMode(PDO::FETCH_ASSOC);
		for ($i=0;$i<$num;$i++){
		$art = $stmt->fetch();
		$tmpart[] = $art;
		$cat_ids[$i] = $tmpart[$i]['driver_id'];
 
		}
	}
 
      foreach ($cat_ids as $cat) {
 
      $sql= 'select * from graph where driver = :driver';
      $stmt = $hDB->prepare($sql);
      $stmt->bindParam(':driver',$cat,PDO::PARAM_INT);
      $stmt->execute();
      $num = $stmt->rowCount();
 
		  if ($num>0){
		  $arty = $stmt->setFetchMode(PDO::FETCH_ASSOC);
			  for ($i=0;$i<$num;$i++){
				$arty = $stmt->fetch();
				$arty['note'] = html_entity_decode(stripslashes($arty['note']),ENT_QUOTES,'utf-8');
				$tmparty[$arty['driver']][] = $arty;
			  }
 
		  }
 
      }
      $smarty->assign('lsc',$tmpart);
      $smarty->assign('plsc',$tmparty);
[PHP] pobierz, plaintext 

nastepnie rysuję sobie wiersze i komórki:

[HTML] pobierz, plaintext 
<!-- zawartośc tabel -->   
    <div class="rightd" id="rightd">
            {section start=0 step=1 name=tmpart loop=$lsc}
            <div style="width:2765px;overflow:hidden;">	
 
                    	{assign var=idc value=$lsc[tmpart].drivers_id}
 
                     	{section start=0 step=1 name=arty loop=52}
                        		{if $smarty.section.arty.rownum == $plsc[$idc][arty].week}
                                <div data-week="{$smarty.section.arty.rownum}" data-driver_id="{$lsc[tmpart].driver_id}" data-driver_name="{$lsc[tmpart].name}" class="cell tips w{$smarty.section.arty.rownum}" id ="w{$smarty.section.arty.rownum}d{$lsc[tmpart].driver_id}" tip="week {$smarty.section.arty.rownum} " onClick="showdial('klasa', '500', this);" >
                                1
                                </div>
                                {else}
                                <div data-week="{$smarty.section.arty.rownum}" data-driver_id="{$lsc[tmpart].driver_id}" data-driver_name="{$lsc[tmpart].name}" class="cell tips w{$smarty.section.arty.rownum}" id ="w{$smarty.section.arty.rownum}d{$lsc[tmpart].driver_id}" tip="week {$smarty.section.arty.rownum} " onClick="showdial('klasa', '500', this);" >
 
                                </div>
                                {/if}
                    	{/section}
 
 
                <div class="clearing"></div>
 
            </div> 
            {/section}   
    </div>
    <div class="clearing"></div>
    <!-- end zawartośc tabel --> 
[HTML] pobierz, plaintext 

N i wiem,że w rysowaniu kkomórek jest zle bo póki co mam puste komórki i ani tak ani siak.
Poprosze o pomoc.

[kasior]

ok ok (IMG:style_emoticons/default/smile.gif) Pobrałem dane i mam teraz cos takiego:

[PHP] pobierz, plaintext 
Array
(
    [7] => Array
        (
            [0] => Array
                (
                    [graph_id] => 17
                    [driver] => 7
                    [week] => 1
                    [status] => 2
                    [color] => 91de2d
                    [note] => 
                    [truck] => 3
                )
 
            [1] => Array
                (
                    [graph_id] => 18
                    [driver] => 7
                    [week] => 10
                    [status] => 4
                    [color] => fff555
                    [note] => 
                    [truck] => 3
                )
 
            [2] => Array
                (
                    [graph_id] => 19
                    [driver] => 7
                    [week] => 8
                    [status] => 2
                    [color] => 91de2d
                    [note] => 
                    [truck] => 0
                )
 
        )
 
    [8] => Array
        (
            [0] => Array
                (
                    [graph_id] => 20
                    [driver] => 8
                    [week] => 7
                    [status] => 3
                    [color] => ff4444
                    [note] => 
                    [truck] => 0
                )
 
            [1] => Array
                (
                    [graph_id] => 21
                    [driver] => 8
                    [week] => 1
                    [status] => 3
                    [color] => ff4444
                    [note] => 
                    [truck] => 0
                )
 
        )
 
)
[PHP] pobierz, plaintext 

wyświetlam:

[HTML] pobierz, plaintext 
<!-- zawartośc tabel -->   
    <div class="rightd" id="rightd">
            {section start=0 step=1 name=tmpart loop=$lsc}
            <div style="width:2765px;overflow:hidden;">	
 
                    	{assign var=idc value=$lsc[tmpart].driver_id}
 
                     	{section start=0 step=1 name=arty loop=$plsc[$idc]}
 
 
                                <div data-week="{$smarty.section.arty.rownum}" data-driver_id="{$lsc[tmpart].driver_id}" data-driver_name="{$lsc[tmpart].name}" class="cell tips w{$smarty.section.arty.rownum}" id ="w{$smarty.section.arty.rownum}d{$lsc[tmpart].driver_id}" tip="week {$smarty.section.arty.rownum} " onClick="showdial('klasa', '500', this);" >
                                {$plsc[$idc][arty].week}
                                </div>
						{sectionelse}
 
                    	{/section}
 
 
                <div class="clearing"></div>
 
            </div> 
            {/section}   
    </div>
    <div class="clearing"></div>
    <!-- end zawartośc tabel --> 
 
[HTML] pobierz, plaintext 

i mam:

(IMG:http://peterwebs.pl/tabela2.jpg)

Niby ok, ale co tu dopisac w wyświetlaniu, zeby puste komórki pokazało jak nie ma danych (IMG:style_emoticons/default/questionmark.gif)

mogę zronbić srodkowa pętle tak:

[HTML] pobierz, plaintext 
{section start=0 step=1 name=arty loop=52}
 
 
                                <div data-week="{$smarty.section.arty.rownum}" data-driver_id="{$lsc[tmpart].driver_id}" data-driver_name="{$lsc[tmpart].name}" class="cell tips w{$smarty.section.arty.rownum}" id ="w{$smarty.section.arty.rownum}d{$lsc[tmpart].driver_id}" tip="week {$smarty.section.arty.rownum} " onClick="showdial('klasa', '500', this);" >
                                {if $plsc[$idc][arty].week}{$plsc[$idc][arty].week}{else}-{/if}
                                </div>
						{sectionelse}
 
                    	{/section}
[HTML] pobierz, plaintext 

i wynik:
(IMG:http://peterwebs.pl/tabela3.jpg)

ale ciągle nie wskakuja komórki na swoje miejsca.