Smarty help.

Craig321 · 28 Mar 2006 at 22:37

Hi,

Stuck a bit on Smarty

I have this:

Code:

$count = array();

	$sqlcAccounts = sprintf("SELECT * FROM Accounts WHERE Category = %s", quote_smart($field['ID']));
	$sqlcItems = sprintf("SELECT * FROM Items WHERE Category = %s", quote_smart($field['ID']));
	$sqlcAccountsR = mysql_query($sqlcAccounts);
	$sqlcItemsR = mysql_query($sqlcItems);

	$count[] = array(
			'count_accounts' => mysql_num_rows($sqlcAccountsR),
			'count_items' => mysql_num_rows($sqlcItemsR)
			);

$smarty->assign('count', $count);

And the tpl file:

Code:

		{section loop=$count name=count}
		<td>{$count[count].count_accounts}</td>
		<td>{$count[count].count_items}</td>
		{/section}

lookitsjonno · 28 Mar 2006 at 23:03

hmm whats the point in the count array and the loop in your template?

wouldn't this be sufficient?

Code:

	$sqlcAccounts = sprintf("SELECT * FROM Accounts WHERE Category = %s", quote_smart($field['ID']));
	$sqlcItems = sprintf("SELECT * FROM Items WHERE Category = %s", quote_smart($field['ID']));
	$sqlcAccountsR = mysql_query($sqlcAccounts);
	$sqlcItemsR = mysql_query($sqlcItems);

$smarty->assign('count_accounts', mysql_num_rows($sqlcAccountsR));
$smarty->assign('count_items', mysql_num_rows($sqlcItemsR));

Code:

		<td>{$count_accounts}</td>
		<td>{$count_items}</td>

robmiller · 28 Mar 2006 at 23:55

I'm fairly certain you can use a few whitelisted functions from within Smarty, and iirc count is one of them. You can, therefore, just do:

Code:

$foo = array(1, 2, 'lol', 'whatever');

$smarty->assign('foo', $foo);

Code:

<p>{count($foo)} items</p>

{foreach from=$foo item=lol}
<p>{$lol}</p>

Totally untested as a result of my own laziness, though.

Craig321 · 29 Mar 2006 at 01:32

count doesn't seem to exist rob

gives an error on the script & it isn't in the Smarty DB

jonno.co.uk said:

hmm whats the point in the count array and the loop in your template?

wouldn't this be sufficient?

Code:

	$sqlcAccounts = sprintf("SELECT * FROM Accounts WHERE Category = %s", quote_smart($field['ID']));
	$sqlcItems = sprintf("SELECT * FROM Items WHERE Category = %s", quote_smart($field['ID']));
	$sqlcAccountsR = mysql_query($sqlcAccounts);
	$sqlcItemsR = mysql_query($sqlcItems);

$smarty->assign('count_accounts', mysql_num_rows($sqlcAccountsR));
$smarty->assign('count_items', mysql_num_rows($sqlcItemsR));

Code:

		<td>{$count_accounts}</td>
		<td>{$count_items}</td>

There will be more than one row in the table(s) that need to be counted, when I do the above only the result it outputted for the bottom table

The closest I have got to making it work is with the code in my first post

But that prints all the results out the results but in a line on each row instead of in the correct places.

Bloo_Fish · 29 Mar 2006 at 07:31

Craig321 said:
count doesn't seem to exist rob gives an error on the script & it isn't in the Smarty DB

IIRC it would be

Code:

<p>{$foo|@count} items</p>

Untested as i am just as lazy as Rob

Craig321 · 29 Mar 2006 at 14:41

Hi,

Where do the SQL queries come into the count.

I put a $field['Blah']; into an array and then into a foreach on the template in a count meaning it should count shouldn't it?

Craig.

robmiller · 29 Mar 2006 at 19:25

Craig321 said:
I put a $field['Blah']; into an array and then into a foreach on the template in a count meaning it should count shouldn't it?

Whaaaat?

Craig321 · 29 Mar 2006 at 21:53

Well I need to count MySQL entries according to the category ID and then output them in two columns in a table and I'm not sure how to use MySQL and the count function to do this.

Craig.

Craig321 · 30 Mar 2006 at 21:17

Craig321 · 1 Apr 2006 at 01:19

Argh, anyone know please :S

Craig.