I thought I'd follow up on this post. The website this function was for has been on hold, and I've just started work on it.
To achieve what I was after has been very easy. Firsly the DataTables JavaScript does everything I want with regards to searching and sorting.
Then to link to a particular row's data on it's own page. In render/render.class.php I modified line 247 like this:
// JOE MOD
// Old Code
// $row_cells[] = "<{$tag}{$span_attr}{$class_attr}{$style_attr}>{$cell_content}</${tag}>";
// New code
if($col_idx == 0 && $row_idx != 0){
$row_cells[] = "<{$tag}{$span_attr}{$class_attr}{$style_attr}><a href='".get_bloginfo('url')."/our-wines/wine-detail/?id=".$row_idx."'>{$cell_content}</a></${tag}>";
} else {
$row_cells[] = "<{$tag}{$span_attr}{$class_attr}{$style_attr}>{$cell_content}</${tag}>";
}
// END JOE MOD
Then in my functions.php file I addded:
function get_tablefield($tableid, $rowid, $fieldname){
$tabledata = get_option('wp_table_reloaded_data_'.$tableid);
$columncount = count($tabledata['data'][0]);
for($i=0; $i < $columncount; $i++){
if($tabledata['data'][0][$i] == $fieldname){
return $tabledata['data'][$rowid][$i];
}
}
}
Then I created a new WordPress page with its own page template to display the data (this page URL must match the URL in the code I added to render/render.class.php). In the page template, I put this:
<?php echo get_tablefield(1, $_GET['id'], "Name"); ?>
replacing 1 with the table ID, and "Name" with the column name I wish to display.
Hope this helps anyone who wants to achieve the same result.
