retrieve data (query) problem smarty

Hi,

I recently installed 'collabtive' (project management script in some sort of mvc with smarty engine).
Although it is my first time using the smarty engine I kind of managed to retrieve some data from my database.

One problem though:
I only get the amount of data from the database but with no text or what so ever.
To be more exact, I have 7 rows in mysql, and also get them on my page, but they are just empty rows.

The code itself is kind of long, but I still hope you guys could help me.


EDIT: don't mind the tools column, I still have to fix that

class.webportoflio.php
----------------------

function getportfolio($id)
    {
        $id = (int) $id;

        $sel = mysql_query("SELECT * FROM portfolio WHERE ID = $id LIMIT 1");
      $portfolio = mysql_fetch_array($sel,MYSQL_ASSOC);
      
        if (!empty($portfolio))
        {
         $portfolio["id"] = stripslashes($portfolio["id"]);
         $portfolio["name"] = stripslashes($portfolio["name"]);
            $portfolio["description"] = stripslashes($portfolio["description"]);
            return $portfolio;
        }
        else
        {
            return false;
        }
    }
    function getportfolios()
    {
        $category = mysql_real_escape_string($category);

        $portfolios = array();
        $sel1 = mysql_query("SELECT id, name, description FROM portfolio");

        while ($portfolio = mysql_fetch_array($sel1))
        {
            $theportfolio = $this->getportfolio($portfolio["ID"]);
            array_push($portfolios, $theportfolio);
        }

        if (!empty($portfolios))
        {
            return $portfolios;
        }
        else
        {
            return false;
        }
    }


----------------------
manageportfolio.php
----------------------

$portfolio = new webportfolio();
$listportfolio = $portfolio->getportfolios($id);
....
if ($action == "config")
{
   $title = $langfile['configwebsite'];
   $template->assign("title", $title);
   $template->display("configwebsite.tpl");
} elseif ($action == "portfolio")
{
      $title = $langfile['addportfolio'];
      $template->assign("title", $title);
      $template->assign("getlistportfolio", $listportfolio);
      $template->display("showportfolio.tpl");
....

----------------------
showportfolio.tpl
----------------------

<div class="block" id="website" style = "{$websitestyle}">
            <table cellpadding="0" cellspacing="0" border="0">

               <thead>
                  <tr>
                     <th class="a"></th>
                     <th class="b">{#title#}</th>
                     <th class="c">{#description#}</th>
                     <th class="tools"></th>
                  </tr>
               </thead>

               <tfoot>
                  <tr>
                     <td colspan="4"></td>
                  </tr>
               </tfoot>

               {section name=portfolio loop=$getlistportfolio}

               {*Color-Mix*}
               {if $smarty.section.portfolio.index % 2 == 0}
               <tbody class="color-a" id="proj_{$getlistportfolio[portfolio].id}">
               {else}
               <tbody class="color-b" id="proj_{$getlistportfolio[portfolio].id}">
               {/if}
                  <tr>
                     <td></td>
                     <td>{$getlistportfolio[portfolio].id}</td>
                     <td>{$getlistportfolio[portfolio].description}</td>
                     <td class="tools">
                          {if $userpermissions.projects.edit}
                        <a class="tool_edit" href="manageproject.php?action=editform&amp;id={$getlistportfolio[portfolio].id}" title="{#edit#}" ></a>{/if}
                        {if $userpermissions.projects.del}
                        <a class="tool_del" href="javascript:confirmfunction('{#confirmdel#}','deleteElement(\'proj_{$getlistportfolio[portfolio].id}\',\'manageproject.php?action=del&amp;id={$getlistportfolio[portfolio].id}\')');"  title="{#delete#}"></a>
                        {/if}
                     </td>
                  </tr>

                  <tr class="acc">
                     <td colspan="5">
                        <div class="accordion_toggle"></div>
                        <div class="accordion_content">
                           <div class="acc-in">
                              <div class="message-in">
                                 {$getlistportfolio[portfolio].desc}
                              </div>
                           </div>
                        </div>
                     </td>
                  </tr>
               </tbody>
               {/section}

            </table>

            <div class="tablemenue"></div>


      </div> {*block END*}

Open in new window

LVL 3
MutsopAsked:
Who is Participating?
 
wizzie83Connect With a Mentor Commented:
Case sensitive query:

change all ID in id (lowercase)
0
 
MutsopAuthor Commented:
Why? WHY? WHYYYYY Does it work now :D
Thanks alot

Such a quick response and to the point :)

Thanks
0
 
wizzie83Commented:
Has to do with the filesystem of the server. Also can be manipulated by mysql var.
--lower_case_table_names
0
All Courses

From novice to tech pro — start learning today.