slaterino

I am currently using a simple array with a grid layout that outputs from Wordpress, which allows me to specify the three columns of the grid. Now, I am wanting to add something hard-coded into the third column of the first row. Which essentially means that my array would need to go 'first,second' for the first row (then I will add my hard-coded item in the third column) and then 'first,second,third' infinitely after that. Is there any way that this is possible to implement practically, so that the array just goes 'first' and 'second' and then switches to the 'first','second,'third' array? Here's the current code that I'm using: $style_classes = array('first','second','third'); $styles_count = count($style_classes); $style_index = 0; <div class="grid_5 <?php $k = $style_index % $styles_count; echo "$style_classes[$k]"; $style_index++; ?>">

Hi, I'm having a real problem with one of my Wordpress category pages. I use a 3-column grid system on this page and just recently I needed to add an advert to the page, so I thought I would do one query at the top with the first two posts, then add the advert to complete the row. Then I would use a second query underneath creating the posts using the traditional grid system with 3 in each row. This is working well except for the pagination, which adds the two items form the first query everytime it paginates. You can see this in action at http://soundsandcolours.com/music/ Does anyone know what I can do to make the Pagination ignore the first query, and just keep running the second query instead. I've included all of my code below: 1st Query: $query_string; $musiccat_posts = new WP_Query($query_string."&posts_per_page=2"); if ($musiccat_posts->have_posts()): $musiccatIDs = array(); while($musiccat_posts->have_posts()):$musiccat_posts->the_post(); $musiccatIDs[] = get_the_ID(); 2nd Query: $paged = ( get_query_var( 'paged' ) ) ? absint( get_query_var( 'paged' ) ) : 1; global $moremusiccat_query; $music_args = array( 'cat' => 1841, 'posts_per_page' => 15, 'post__not_in' => $musiccatIDs, 'paged' => $paged ); $moremusiccat_query = new WP_Query( $music_args ); while ($moremusiccat_query -> have_posts()) : $moremusiccat_query -> the_post(); ?> Pagination Code: $big = 999999999; // need an unlikely integer echo paginate_links( array( 'base' => str_replace( $big, '%#%', esc_url( get_pagenum_link( $big ) ) ), 'format' => '?paged=%#%', 'current' => max( 1, get_query_var('paged') ), 'total' => $moremusiccat_query->max_num_pages ) ); Any help would be massively appreciated!

Hey, that's what I thought too. However, none of the files listed actually ever existed, which is why I think there has been some hacking at some point that is causing the problem.

Hi, Apologies if this isn't the right forum for this question. I couldn't find the perfect forum for my question, but I'm hoping someone can help. Basically, I've been having problems with a site I manage, with the site going down regularly, 401 Forbidden error pages cropping up reguarly, as well as Server Configuration Error pages, although only ever sporadically. I've been trying everything to work out the issue but no luck as of yet. However, one thing that seems strange is the following messages that I'm getting in the access logs. Now, this shouldn't be a problem as Facebook often creates messages like these when it's accessing files from a server. However, there are thousands of messages like this that reference files that don't exist. Honestly, it's constantly trying to access .jpg files that don't exist, and so I suspect this is what's causing the server to keep crashing. Has anyone had anything similar to this before? comono.co.uk 173.252.88.88 - - [20/Nov/2015:13:13:46 +0000] "GET /uploads/2009/9/28/873128bf77.jpg HTTP/1.1" 403 379 "-" "facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)" Thanks, Russ

Hi, I am currently building a site which works perfectly as it is. However, I am now trying to add mobile responsiveness and having trouble with what I think is the order in which the JavaScript files are loading. Essentially, I have a slideshow on the main page but I don't want this to load on mobile devices so am using Enquire.js to set some parameters. However, even though it looks like it's working in the code there are some problems. First off, in my script, I load the JavaScript files: <script src="http://code.jquery.com/jquery-1.11.0.min.js" type="text/javascript" charset="utf-8"></script> <script src="http://cdn.jquerytools.org/1.2.7/full/jquery.tools.min.js" type="text/javascript" charset="utf-8"></script> Then I load the loadJS function and initialise the jQuery tool: <script type="text/javascript"> function loadJS(url) { var head = document.getElementsByTagName('head')[0]; var script = document.createElement('script'); script.type = 'text/javascript'; script.src = url; head.appendChild(script); }; (function($) { jQuery('#slides').slides({ preload: true, generateNextPrev: true }); }); </script> This all works fine. My problem is that I want jQuery Tools to only open if the computer is not a mobile. So, instead of loading the script in the header I have this script later on in the file: enquire.register("screen and (min-width: 900px)", { match : function() { loadJS('http://cdn.jquerytools.org/1.2.7/full/jquery.tools.min.js'); console.log('desktop loaded'); } }); However, even though that script loads the JavaScript in the header the jQuery Tools are not initialising properly and the slideshow is not working. Why is this happening? Any help even with how I can debug this would be really appreciated. Thanks, Russ

Hey all, sorry to come back onto this topic, but I have one final question. Essentially I need my data to be sorted by two different valuables, the date and the artist name. When I do a Foreach loop such as the one in the example above is there any way of sorting the $artist_name field alphabetically?

And in case anyone wants to see the final code, here it is: $todaysDate = date('Y/m/d'); global $post; $args = array( 'post_type' => 'event', 'orderby' => 'meta_value', 'meta_key' => 'event_date', 'meta_compare' => '>', 'meta_value' => $todaysDate, 'numberposts' => 6, 'order' => 'ASC' ); $whatson = get_posts( $args ); $output_array = array(); foreach( $whatson as $post ) : if (get_post_meta($post->ID, '2artist', true)) : $artist_name = get_the_title(get_post_meta($post->ID, '2artist', true)); elseif (get_post_meta($post->ID, '2artist_non', true)) : $artist_name = get_post_meta($post->ID, '2artist_non', true); endif; $event_date = date('D j M', strtotime(get_post_meta($post->ID, 'event_date', true))); $output_array[$artist_name][] = $event_date; endforeach; foreach($output_array as $artists=>$events) : echo "<h1>$artists</h1>"; foreach($events as $event) : echo "<h2>$event</h2>"; endforeach; endforeach;

Guys. I got it! Sorry, I forgot to take out the $output_array from within the loop! I think I can work from what I have now. It looks like it works a charm. Thanks for your help!

Hmm, I just tried that Barand so that my code looks like the below, but my array only includes one entry, the last entry. Is there something I'm missing? $output_array = array(); foreach( $whatson as $post ) : if (get_post_meta($post->ID, '2artist', true)) : $artist_name = get_the_title(get_post_meta($post->ID, '2artist', true)); elseif (get_post_meta($post->ID, '2artist_non', true)) : $artist_name = get_post_meta($post->ID, '2artist_non', true); endif; $event_date = date('D j M', strtotime(get_post_meta($post->ID, 'event_date', true))); $output_array = array(); $output_array[$artist_name][] = $event_date; endforeach; print_r($output_array); And that's just outputting: Array ( [Artist Name #2] => Array ( [0] => Thu 20 Dec ) )

And just to make clear, this is the output I'm getting: Array ( [Artist Name #1] => Array ( [0] => Tue 20 Nov ) ) Array ( [Artist Name #2] => Array ( [0] => Wed 28 Nov ) ) Array ( [Artist Name #2] => Array ( [0] => Thu 20 Dec )

Hey, I've tried using this two-dimensional array but still getting the standard result, which is where the artist names are not grouped together. I've included the code below. I can't help but think that I would need to break out of the initial foreach loop to be able to do this. Do you know what I mean? Here's the code: $args = array( 'post_type' => 'event', 'orderby' => 'meta_value', 'meta_key' => 'event_date', 'meta_compare' => '>', 'meta_value' => $todaysDate, 'numberposts' => 6, 'order' => 'ASC' ); $whatson = get_posts( $args ); foreach( $whatson as $post ) : $artist_name = get_the_title(get_post_meta($post->ID, '2artist', true)); $event_date = date('D j M', strtotime(get_post_meta($post->ID, 'event_date', true))); $output_array = array(); $output_array[$artist_name][] = $event_date; foreach($output_array as $artists=>$events){ print_r($output_array); echo "<h1>$artists</h1>"; foreach($events as $event){ echo "<h2>$event</h2>"; } } endforeach;

Okay, I've created an array now within the current foreach loop. How can I now echo this so that the outputted values are grouped by the artist name?? Here's the array: if (get_post_meta($post->ID, '2artist', true)) : $artist_name = get_the_title(get_post_meta($post->ID, '2artist', true)); elseif (get_post_meta($post->ID, '2artist_non', true)) : $artist_name = get_post_meta($post->ID, '2artist_non', true); endif; $event_date = date('D j M', strtotime(get_post_meta($post->ID, 'event_date', true))); $artists = array(); //define dates array. $artists[] = $artist_name; $artists[] = $event_date; print_r ($artists);

Hi, I'm hoping this is something quite basic. I'm trying to group values from a MySQL query into an array. I have a Wordpress set-up but I'm presuming this is more of a PHP rather than a Wordpress concern. I just want to know basically what is the best way of doing this. Essentially I currently have the following data: Artist Name #1 - Event Date #1 Artist Name #2 - Event Date #2 Artist Name #1 - Event Date #3 Artist Name #1 - Event Date #4 And I want to find a way that I can group the Artist Names so that the data would output like this: Artist Name #1 Event Date #1 Event Date #3 Event Date #4 Artist Name #2 Event Date #2 This is the code I have at the moment. How would I integrate an array and an extra Foreach loop to get the data organised like this. I'm still learning Arrays at the moment and would appreciate any assistance with this. global $post; $args = array( 'post_type' => 'event', 'orderby' => 'meta_value', 'meta_key' => 'event_date', 'meta_compare' => '>', 'meta_value' => $todaysDate, 'numberposts' => 6, 'order' => 'ASC' ); $whatson = get_posts( $args ); foreach( $whatson as $post ) : echo get_the_title(get_post_meta($post->ID, '2artist', true)) . " - "; echo get_post_meta($whatson_query->ID, 'event_date', true); endforeach; Thanks! Russ

Hey, Thanks for the advice. Literally, there will only be 1 or none results so my query is just to find out whether that one result exists or not. So, I think I will do it the way that fugix suggested. Cheers!

Right, I have a table with two fields. One of these is $event_ID, the other is $object_ID. In php, I am running a while loop for all my $event_ID's taking data from another table. Now, in that while loop all I want to do is search through the table I just mentioned and find any matching $event_ID's. If the $object_ID = 7 I simply then want to echo a little bit of data. What's the best way of doing this? I was thinking that I should create an SQL query, i.e. "SELECT event_ID, object_ID FROM event_object_table WHERE event_ID = '$event_ID', and then running another WHILE loop with an IF clause saying something like: IF ($object_ID = 7) {echo "true";} Is this the best way to do this? Or is there a more efficient way? That's really what I'm after!

Hi, I have a SQL query which I have posted below. On a page on my site I want to use this query many times, each time with a slightly different WHERE clause, so that one time it will say "WHERE cat_id = 6" the next time "WHERE cat_id = 7" and so on. The only thing is that I am wary that having lots of queries will take up a lot of memory and make the page load very slowly. Is there anyway that I can re-use parts of the query that have already been processed, but then just add the WHERE clause each time for the data. Basically, what's the best way of doing this in terms of performance? Thanks! Here's the code: $sql = "SELECT post_id, DATE_FORMAT(start,'%m/%d/%Y') AS eventStart, DATE_FORMAT(end,'%m/%d/%Y') AS eventEnd, DATE_FORMAT(CURDATE(),'%m/%d/%Y') AS today, DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 7 DAY),'%m/%d/%Y') AS endWeek FROM wp_ec3_schedule s JOIN wp_posts p ON p.ID = s.post_id WHERE post_status = 'publish' "; $clause = array(); for( $i = 0; $i < 365; $i++ ) { $clause[] = "DATE_ADD(CURDATE(), INTERVAL $i DAY) BETWEEN DATE(start) AND DATE(end)"; } $sql .= "AND (" . implode(' OR ', $clause) . ")"; $sql .= ' ORDER BY start DESC'; $perf_result = mysql_query($sql) or trigger_error($sql . ' has failed. <br />' . mysql_error());

Hi, I've got a script that generates a list of the next seven days. However, as today becomes tomorrow it seems that the dates are not changing automatically as they should do! Does php sometimes store data in a cache. How can I reset this so that this won't happen? I'm using this query to capture the date, and do a bit of coding with it, and then I'm echo'ing the date later in the script. How can I make sure it changes as soon as midnight hits? $sql = "SELECT post_id, DATE_FORMAT(start,'%m/%d/%Y') AS eventStart, DATE_FORMAT(end,'%m/%d/%Y') AS eventEnd, DATE_FORMAT(CURDATE(),'%m/%d/%Y') AS today, DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 7 DAY),'%m/%d/%Y') AS endWeek FROM wp_ec3_schedule s JOIN wp_posts p ON p.ID = s.post_id WHERE post_status = 'publish' "; $clause = array(); for( $i = 0; $i < 7; $i++ ) { $clause[] = "DATE_ADD(CURDATE(), INTERVAL $i DAY) BETWEEN DATE(start) AND DATE(end)"; } $sql .= "AND (" . implode(' OR ', $clause) . ")"; $sql .= ' ORDER BY start DESC'; $result = mysql_query($sql) or trigger_error($sql . ' has failed. <br />' . mysql_error()); //pull data from database.

Hi, I'm so very close to getting the information I need but just have one final hurdle. I have created an array called $data but just need some help getting the data back out of the array. This is my loop where I am trying to output the data: foreach($data as $date => $v) { echo date('D', strtotime($date)) . '<br />'; echo date('d', strtotime($date)) . '<br />---------<br />'; foreach($v as $event) { echo $event; echo "<br />"; } echo '<br />'; } The first loop works fine where I am outputting the dates, but then the $event value is incorrect. At the moment I am simply getting 'Array' for the $event value. However I want to be able to get two values, the ID and the date that are in the array. How do I get this data out of the array? I have been looking at the array() page at php.com for hours trying to work this one out but still can't get there! Here's the result of "print_r($data,true)": Array ( [06/09/2011] => Array ( [0] => Array ( [13] => 06/09/2011 ) [1] => Array ( [15] => 06/08/2011 - 06/10/2011 ) ) [06/10/2011] => Array ( [0] => Array ( [15] => 06/08/2011 - 06/10/2011 ) ) [06/11/2011] => [06/12/2011] => [06/13/2011] => Array ( [0] => Array ( [6] => 06/13/2011 ) ) [06/14/2011] => [06/15/2011] => )

Okay, so using nested arrays is fine. Just one question, how the hell do I do that? I currently have a $data array which contains this information for my test data: Essentially for each one of the ID numbers (13,15,6) I would need an eventStart date and an eventEnd date. So, this would mean creating an array within that array - is that correct? I've pasted my current code again below. Any help on this would be massively appreciated. I'm just starting to understand arrays so to jump up to nested arrays is proving quite tricky!!! <?php $sql = "SELECT post_id, DATE_FORMAT(start,'%m/%d/%Y') AS eventStart, DATE_FORMAT(end,'%m/%d/%Y') AS eventEnd, DATE_FORMAT(CURDATE(),'%m/%d/%Y') AS today, DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 7 DAY),'%m/%d/%Y') AS endWeek FROM $ec3->schedule s JOIN $wpdb->posts p ON p.ID = s.post_id WHERE post_status = 'publish' "; $clause = array(); $htmlOutput = ''; for( $i = 0; $i < 7; $i++ ) { $clause[] = "DATE_ADD(CURDATE(), INTERVAL $i DAY) BETWEEN DATE(start) AND DATE(end)"; } $sql .= "AND (" . implode(' OR ', $clause) . ")"; $sql .= ' ORDER BY start DESC'; $result = mysql_query($sql) or trigger_error($sql . ' has failed. <br />' . mysql_error()); //pull data from database. $dates = array(); //define dates array. for($i = 0; $i < 7; $i++) { $dates[] = date('m/d/Y', strtotime("+$i days")); //fill dates array with every date from now until 7 days from now. } foreach($dates as $days) { //go through dates array. $data[$days] = NULL; //fill data array with keys for every date from now until 7 days. } if(mysql_num_rows($result) > 0) { while($r = mysql_fetch_assoc($result)) { //while data exists in the database result resource. if(strtotime($r['eventStart']) < strtotime($r['today'])) { //if the event started before today. $r['eventStart'] = $r['today']; //make it's startdate today. } if(strtotime($r['eventEnd']) > strtotime($r['endWeek'])) { //if the event ends after this week is over. $r['eventEnd'] = $r['endWeek']; //make the end of the week, it's end. } $started = false; //define a false variable. foreach($data as $key => $value) { //loop through our data array. if($key == $r['eventStart'] && $started == false) { //if the event starts at the present key, put it in the array. $data[$key][] = $r['post_id']; $started = ($key == $r['eventEnd']) ? false : true; //set started to true. } elseif($key == $r['eventEnd']) { //if the eventEnd is the present key, put it in the array, $data[$key][] = $r['post_id']; $started = false; //set started to false; } elseif($started == true) { //if started is true, then put the event in the array. $data[$key][] = $r['post_id']; } } } foreach($data as $date => $v) { //loop through the data array. echo date('D', strtotime($date)) . '<br />'; //echo the $date, followed by a line. echo date('d', strtotime($date)) . '<br />---------<br />'; //echo the $date, followed by a line. foreach($v as $event) { $event_post = get_post($event); $title = $event_post->post_title; echo "Date of event:<br />"; echo $title . "<br />"; //each event is then echo'd to the page, followed by a break rule. } echo '<br />'; //after all of the events on this day, print another break rule, double spacing before the next date. } } else { echo 'No rows to show!'; } ?>

Okay, cheers for the suggestions. What's the general consensus on this issue? Is it better to use an array or htmloutput? The number one priority is for the site to be fast, so would that mean using html output? Best, Russ

I am working with some code, which I've pasted below, and have a query about. I am outputting some data in the foreach loop at the bottom on my site. Now, my question is how can I store information from the start to echo out at the bottom. What I want is three pieces of information. I want the start date (eventStart) for each event, end date (eventEnd) for each event and also a simple statement which would say 'true' if the day of start date was the same as the end date or 'false' if they are different. What's the best way of using this data later on. Is it using an array? Sorry for being a bit thick but I'm just beginning to get my head around this whole array thing! Thanks for any future help, and here's my code... <?php $sql = "SELECT post_id, DATE_FORMAT(start,'%m/%d/%Y') AS eventStart, DATE_FORMAT(end,'%m/%d/%Y') AS eventEnd, DATE_FORMAT(CURDATE(),'%m/%d/%Y') AS today, DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 7 DAY),'%m/%d/%Y') AS endWeek FROM $ec3->schedule s JOIN $wpdb->posts p ON p.ID = s.post_id WHERE post_status = 'publish' "; $clause = array(); for( $i = 0; $i < 7; $i++ ) { $clause[] = "DATE_ADD(CURDATE(), INTERVAL $i DAY) BETWEEN DATE(start) AND DATE(end)"; } $sql .= "AND (" . implode(' OR ', $clause) . ")"; $sql .= ' ORDER BY start DESC'; $result = mysql_query($sql) or trigger_error($sql . ' has failed. <br />' . mysql_error()); //pull data from database. $dates = array(); //define dates array. for($i = 0; $i < 7; $i++) { $dates[] = date('m/d/Y', strtotime("+$i days")); //fill dates array with every date from now until 7 days from now. } foreach($dates as $days) { //go through dates array. $data[$days] = NULL; //fill data array with keys for every date from now until 7 days. } if(mysql_num_rows($result) > 0) { while($r = mysql_fetch_assoc($result)) { //while data exists in the database result resource. if(strtotime($r['eventStart']) < strtotime($r['today'])) { //if the event started before today. $r['eventStart'] = $r['today']; //make it's startdate today. } if(strtotime($r['eventEnd']) > strtotime($r['endWeek'])) { //if the event ends after this week is over. $r['eventEnd'] = $r['endWeek']; //make the end of the week, it's end. } // echo '<pre>' . print_r($r,true) . '</pre>'; //de-bugging. $started = false; //define a false variable. foreach($data as $key => $value) { //loop through our data array. if($key == $r['eventStart'] && $started == false) { //if the event starts at the present key, put it in the array. $data[$key][] = $r['post_id']; $started = ($key == $r['eventEnd']) ? false : true; //set started to true. } elseif($key == $r['eventEnd']) { //if the eventEnd is the present key, put it in the array, $data[$key][] = $r['post_id']; $started = false; //set started to false; } elseif($started == true) { //if started is true, then put the event in the array. $data[$key][] = $r['post_id']; } } } foreach($data as $date => $v) { //loop through the data array. echo date('D', strtotime($date)) . '<br />'; //echo the $date, followed by a line. echo date('d', strtotime($date)) . '<br />---------<br />'; //echo the $date, followed by a line. foreach($v as $event) { $event_post = get_post($event); $title = $event_post->post_title; echo "Date of event"; echo $title . '<br />'; //each event is then echo'd to the page, followed by a break rule. } echo '<br />'; //after all of the events on this day, print another break rule, double spacing before the next date. } } else { echo 'No rows to show!'; } ?>

Yes! I worked it out. I was trying all kinds of different LEFT JOINS and INNER JOINS and just couldn't really get my head around it. But worked it out now: <?php $sql = "SELECT post_id, DATE_FORMAT(start,'%m/%d/%Y') AS eventStart, DATE_FORMAT(end,'%m/%d/%Y') AS eventEnd, DATE_FORMAT(CURDATE(),'%m/%d/%Y') AS today, DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 7 DAY),'%m/%d/%Y') AS endWeek FROM $ec3->schedule s JOIN $ec3->post p ON p.post_id = s.post_id WHERE post-status = 'publish' "; $clause = array(); for($i = 0; $i < 7; $i++ ) { $clause[] = "DATE_ADD(CURDATE(), INTERVAL $i DAY) BETWEEN DATE(start) AND DATE(end)"; } if (count($clause) > 0) { $sql .= "AND (" . implode(' OR ', $clause) . ")"; } $sql .= ' ORDER BY start'; ?> Thanks for your help!

Hi, I have got a SQL query which is pulling data out of a table. However, I want the query to get data out of that table only when a criteria from another table is met. So, I want the query to work as it is doing, but to only get fields WHERE post-status = 'publish' IN posts. Both the tables ec3_schedule and post have a field called post_ID which should be joined. How do I create this join? I was trying Left Joins, Inner Joins, Outer Joins and all kinds of other Joins but with no luck. Here is my SQL query without any of the joins: $sql = "SELECT post_id, DATE_FORMAT(start,'%m/%d/%Y') AS eventStart, DATE_FORMAT(end,'%m/%d/%Y') AS eventEnd, DATE_FORMAT(CURDATE(),'%m/%d/%Y') AS today, DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 7 DAY),'%m/%d/%Y') AS endWeek FROM ec3_schedule WHERE "; $clause = array(); for( $i = 0; $i < 7; $i++ ) { $clause[] = "DATE_ADD(CURDATE(), INTERVAL $i DAY) BETWEEN DATE(start) AND DATE(end)"; } $sql .= implode(' OR ', $clause); $sql .= ' ORDER BY start';

jcbones, you're an absolute genius! Thanks so much for your help on this! Thanks for the comments too! I actually think I understand a lot of what's going on! Best, Russ

Okay, so the new code is outputting this: 06/06/2011 21:00:00 until 06/15/2011 21:00:00 => Event 4 06/08/2011 21:00:00 until 06/09/2011 21:00:00 => Event 2 However, thinking about this, and using this as my test data, eventName startDate endDate ID Event 1 2011-06-10 21:00:00 NULL 1 Event 2 2011-06-08 21:00:00 2011-06-09 21:00:00 2 Event 3 2011-06-13 21:00:00 NULL 3 Event 4 2011-06-06 17:00:00 2011-06-15 17:00:00 4 Then this is what I would need to output: 06/08/2011 17:00:00=> Event 4 06/08/2011 21:00:00=> Event 2 06/09/2011 17:00:00=> Event 4 06/09/2011 21:00:00=> Event 2 06/10/2011 17:00:00=> Event 4 06/10/2011 21:00:00=> Event 1 06/11/2011 17:00:00=> Event 4 06/12/2011 17:00:00=> Event 4 06/13/2011 21:00:00=> Event 3 06/13/2011 17:00:00=> Event 4 06/14/2011 17:00:00=> Event 4 This is becoming clearer in my head what I need to achieve - it's just having the coding prowess to achieve it that's my problem!