Re: [theclicklab] Sub Category Display - When Empty

Tue, 06 Dec 2011 00:41:29 -0800

I can't see an attachment, but I think I see where the problem is. You're actually filtering out when depth == 0 in the foreach loop, so the pagesRecords is not actually empty. Perhaps try this when you are getting the records:

    // Subcat navigation - First Level 
    list($pagesRecords, $pagesMetaData) = getCategories(array(     
    'tableName'   => 'pages',   
    'selectedCategoryNum' => '', // defaults to getNumberFromEndOfUrl() 
    'loadUploads' => '0', 
    'where'   =>  'depth <> 0',  // filter out the depth of 0  <----------
    // 'debugSql' =>'true', 
    ));   
?>

Edit: I just noticed you have further filtering on this line:

We should probably add these filters to the getCategories call too.

$selectedCat = pagesRecord['num'] <-- not sure where pagesRecord is defined.

It'll probably be more clear when I see the attachment. Could you try attaching it again?

Thanks.

Edit2: I just thought of another solution that will require less rewriting of your code:


      
            
          
          ' . htmlspecialchars($record['name']) . ''; ?>
          
  

 
    In this Section:

Re: [theclicklab] Sub Category Display - When Empty

Mon, 05 Dec 2011 22:19:01 -0800

You can do it like this:


    In this Section:

Re: [theclicklab] Testing for last item in loop

Mon, 05 Dec 2011 12:04:31 -0800

What I often do for this is use the 'implode' function:


$menuItems = array();
foreach ($pagesRecords as $record){
    $menuItems[] = " " . $record['name']  . ""
}

$menu = implode(' | ', $menuItems);

echo $menu;
?>

http://php.net/manual/en/function.implode.php

Re: [ht1080z] Related multi level category selection in user input

Sat, 03 Dec 2011 13:56:21 -0800

Regions contain prefectures which contain cities, correct?

It looks like you have these all stored in 1 table? So the table would look like:

Region, Prefecture, City
=================

Region1, Prefecture1, City1
Region1, Prefecture1, City2
Region1, Prefecture1, City3
Region1, Prefecture2, City1
...etc.

I would recommend separating it into 3 different tables so it's more normalized and you don't have so much duplicate data.

But if we keep the current format, you can query like this:

SELECT city FROM location WHERE Region = 'Region1' AND Prefecture = 'Prefecture1'

I'm not sure how the depth comes into play. Perhaps you could clarify what your table looks like?

Re: [videopixel] Retrieving section title or table name?

Sat, 03 Dec 2011 13:47:16 -0800

If you used a call like:

list(records, metaData) = getRecords(options)

metaData will contain lots of information about the records.

Also:

showme(records)

will give you a lot of information about the records.

Re: [Toledoh] What about Plugin for SiteMap Generation?

Thu, 27 Oct 2011 20:22:22 -0700

We don't have a plugin for this yet. But for now you can use this sitemap generation tool:

http://enarion.net/tools/phpsitemapng/

The generated page can then be added as a link section in cmsb.