How can I send category ID and get the number of link in this category
Jun 29, 2009, 5:18 AM
Veteran / Moderator (18441 posts)
Jun 29, 2009, 5:18 AM
Post #2 of 7
Views: 4656
get_category_count
return $DB->table('Category')->select( ['Number_of_Links'], { ID => $_[0] } )->fetchrow;
}
call with:
<%get_category_count($ID)%>
(where $ID is the category ID)
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Code:
sub { return $DB->table('Category')->select( ['Number_of_Links'], { ID => $_[0] } )->fetchrow;
}
call with:
<%get_category_count($ID)%>
(where $ID is the category ID)
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 29, 2009, 5:56 AM
Veteran / Moderator (18441 posts)
Jun 29, 2009, 5:56 AM
Post #4 of 7
Views: 4605
Did you copy it over right? Shouldn't have any spaces before "sub {" and after the last "}"
The code should be fine - can't see anything wrong with it.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
The code should be fine - can't see anything wrong with it.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 30, 2009, 2:02 AM
Veteran / Moderator (18441 posts)
Jun 30, 2009, 2:02 AM
Post #7 of 7
Views: 4551
Thanks - its amazing how much easier it is for me too, using the ULTRAGlobals functions - saves me a ton of time writing / finding globals on the forum =)
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!