Smarty

[crxgames]

I am pulling links from my database, and I am trying to append them to the smarty value to be outputted in the template with a {section}.

Here is the function:
[php:1:5ce802da64]
<?php
function outputNavs()
{
global $db, $template, $config;
$template->assign('links','');
$sql = "SELECT * FROM ". HEADER_NAV_TABLE ." ORDER BY nav_id";

if(!$result = $db->query($sql))
{
message_die(GENERAL_ERROR,"Couldn't SQL the header navigation links from the database in " .__FILE__.' on line '.__LINE__.' <br />'.$sql.'<br />'.mysql_error());
}
else
{
//pick up here
while( $row = $db->fetch_row($result))
{
$template->append('links',array('title' => $row['nav_name'], 'url' => $row['nav_link']));
}

}


}
?>[/php:1:5ce802da64]

and in my template I have:

[boots]

Try this instead:

[php:1:d5a1dee1b7]<?php
function outputNavs()
{
global $db, $template, $config;
$sql = "SELECT * FROM ". HEADER_NAV_TABLE ." ORDER BY nav_id";

$links = array();
if(!$result = $db->query($sql))
{
message_die(GENERAL_ERROR,"Couldn't SQL the header navigation links from the database in " .__FILE__.' on line '.__LINE__.' <br />'.$sql.'<br />'.mysql_error());
}
else
{
//pick up here
while( $row = $db->fetch_row($result))
{
$links[] = array('title' => $row['nav_name'], 'url' => $row['nav_link']);
}

}

$template->assign('links', $links);
}

?>[/php:1:d5a1dee1b7]
Building arrays using append() in a loop is less efficient than building the entire array and then passing it via a single assign.

[crxgames]

Still didn't output them.
_________________
My site | My CMS Development site

[boots]

Put a {debug} into your template. It seems like the $links isn't being populated.

[crxgames]

It is being populated...

only thing I can guess is that I am not going through the data correctly in the template.
_________________
My site | My CMS Development site

[boots]

[crxgames]

It was getting the data to the debug. I'll set the debug on smarty on.
_________________
My site | My CMS Development site

[crxgames]

http://216.68.134.98/portal2.0/portal.php?SMARTY_DEBUG whenever my computer is on. It has the values too.
_________________
My site | My CMS Development site

[boots]

According to the debug window, there isn't a variable called $links. There does seem to be one that fits the bill that is called $nav_links. Could that be it?

[crxgames]

No, I made it assign to the name nav_links
_________________
My site | My CMS Development site

[boots]

...and you made your template read from $nav_links? Please, keep your sample code that you post here as close to the real thing as possible.

Anyhow, I'm getting the feeling that I will have to ask you for each piece of information required to solve this little puzzle. As I have no interest in doing that, I suggest you consider providing more details as I can't see what is wrong based on what you posted so far.

Good luck!

[crxgames]

Problem is the array made in the outputNavs function is not being iterated through and displayed, but has data.

Current function:
[php:1:eea11795f6]<?php
//////////////////////////////////////
//Function: outputNavs()
//Ouputs the header navigation links
//////////////////////////////////////
function outputNavs()
{
global $db, $template, $config;
$sql = "SELECT * FROM ". HEADER_NAV_TABLE ." ORDER BY nav_id";

$links = array();
if(!$result = $db->query($sql))
{
message_die(GENERAL_ERROR,"Couldn't SQL the header navigation links from the database in " .__FILE__.' on line '.__LINE__.' <br />'.$sql.'<br />'.mysql_error());
}
else
{
//pick up here
while( $row = $db->fetch_row($result))
{
$links[] = array('title' => $row['nav_name'], 'url' => $row['nav_link']);

}

}

$template->assign('nav_links', $links);
}
?>[/php:1:eea11795f6]

and current tpl:

[crxgames]

Here is the table structure if that helps.

[crxgames]

I have tried the following foreach to just get it to output with no success.

[crxgames]

Someone has to know, I need to have this working by the end of the day.
_________________
My site | My CMS Development site