Hi, Having a bit of trouble with breadcrumbs in Wordpress, the theme has the breadcrumbs feature enabled but only includes the object page and the homepage, I want to add the parent page into the breadcrumbs. Here is the code: <div id="breadcrumbs"> <?php if(function_exists('bcn_display')) { bcn_display(); } else { ?> <a href="<?php echo esc_url( home_url( '/' ) ); ?>"><?php esc_html_e('Home','Aggregate') ?></a> <span class="raquo">&raquo;</span> <?php if( is_tag() ) { ?> <?php esc_html_e('Posts Tagged ','Aggregate') ?><span class="raquo">&quot;</span><?php single_tag_title(); echo('&quot;'); ?> <?php } elseif (is_day()) { ?> <?php esc_html_e('Posts made in','Aggregate') ?> <?php the_time('F jS, Y'); ?> <?php } elseif (is_month()) { ?> …

Member Avatar
Member Avatar
+0 forum 3

I have a CTE based query, to which I pass about 2600 4-tuple latitude/longitude values using joins - these latitude longitude 4-tuples have been ID tagged and held in a second table called coordinates. These top left and bottom right latitude / longitude values are passed into the CTE in order to display the amount of requests (hourly) made within those coordinates for given two timestamps).- I am able to get the total requests per day within the timestamps given, that is, the total count of user requests on every specified day. (E.g. user opts to see every Wednesday or …

Member Avatar
Member Avatar
+0 forum 1

[CODE]----------------------------------------------------------- chan1 |chan2 |chan3 | captureTime |id ----------------------------------------------------------- 20 |21 |25 | 2011-10-11 00:00:00 |1 ----------------------------------------------------------- 21 |18 |19 | 2011-10-11 00:01:00 |1 ----------------------------------------------------------- .... .... .... ----------------------------------------------------------- 20 |25 |21 | 2011-10-11 00:15:00 |1 ----------------------------------------------------------- 21 |18 |14 | 2011-10-11 00:16:00 |1 .... .... .... ----------------------------------------------------------- 15 |26 |23 | 2011-10-11 23:58:00 |1 ----------------------------------------------------------- 17 |14 |32 | 2011-10-11 23:59:00 |1[/CODE] The table store chan1,chan2 and chan3 value every one minute. I want to get the maximum & minimum values for every 10 minutes and also have the corresponding the captureTime for min/max values. Based on those requirments, How …

Member Avatar
Member Avatar
+0 forum 1

I have a table similar to the one below: Month | Item | Qty | Cost of Items purchased Jun | 1 | 10 | 50 May | 1 | 5 | 0 Apr | 1 | 5 | -18 Mar | 1 | 7 | 0 Feb | 1 | 7 | 0 Jan | 1 | 7 | 0 Jun | 2 | 8 | 10 May | 2 | 7 | 22 Apr | 2 | 5 | 17 Mar | 2 | 3 | -45 Feb | 2 | 7 | -31 Jan | 2 | …

Member Avatar
Member Avatar
+0 forum 1

I have a query which generates a soccer standings table and although it works fine there I am trying to implement a couple of variations on it but everything I have tried has failed. I have searched and asked many times and for both problems and it seems as though a subquery would be the solution, but every attempt I have made has not given the desired result. An example of the output can be seen at [URL="http://www.margate-fc.com/content/test/standings.php?season_id=103"]http://www.margate-fc.com/content/test/standings.php?season_id=103[/URL] for the 2010 season and [URL="http://www.margate-fc.com/content/test/standings.php?season_id=104"]http://www.margate-fc.com/content/test/standings.php?season_id=104[/URL] for the 2011 season. I have also attached a dump of the relevant tables in a …

Member Avatar
Member Avatar
+1 forum 3

this query was too hard for me write. so any help is greatly appreciated i have three table , a_device, b_devices and a_app under a_device i have the columns: hostname app_name under b_device i have the columns: hostname cpu_avg mem_avg under c_app i have the columns: app_name department_name I want to count the number of hostnames in table b_device and group them by department_name also i need to get the avg_cpu and avg_mem for each department. right now the avg_cpu and avg_mem is for each hostname. so far i have this: [CODE] SELECT a.hostname, b.cpu_avg, b.mem_avg, c.app_name, c.department_name FROM a_device …

Member Avatar
Member Avatar
+0 forum 1

The End.