I have figured out how to get the page to do what they were looking for using append.

Thanks anyway...

Javascript - including tablesorter and tablesorterPager declarations

3. var xhr = null;
4. var VALIDATION_URL = 'ajax.php';
5. 
   
6. var campaign_summary = {
7. table:null,
8. body:null
9. };
10. 
    
11. var multi_list = {
12. campaign_list: null
13. };
14. 
    
15. var campaign_array = [];
16. 
    
17. function initialize(){
18. campaign_summary.table = $('#campaignTable');
19. campaign_summary.body = $('#campaignTable tbody');
21. /* initialize the campaigns dropdown using the multiselectfilter widget */
22. multi_list.campaign_list = $("#campaign_list");
23. if( multi_list.campaign_list.length){
24. multi_list.campaign_list.multiselect({
25. noneSelectedText: "Select One or More Campaigns",
26. selectedText: "# of # campaigns",
27. minWidth: 550
28. }).multiselectfilter();
29. }
30. 
    
31. 
    
32. /* get the values on submit */
33. $("form").on("submit", function(e){
34. e.preventDefault();
35. campaign_array = multi_list.campaign_list.multiselect("getChecked").map(function(){
36.     return this.value;    
37. }).get();
39. console.log('Campaign Array: ', campaign_array);
40. 
    
41. var ajaxObj = $.ajax({
42. url : VALIDATION_URL + '?operation=get_campaign_summary&campaign_array=' + campaign_array,
43.             type    : $(this).attr('method'),
44.             dataType: 'json',
45.             data    : $(this).serialize(),
46.             success : function( data, url ) {
47.                         console.log('Submitted: ', data);
48.                       },
49.             error   : function( data, xhr, err ) {
50.                         console.log('Oops: ', data, xhr , err);
51.                       }
52.         }); 
53. console.log('ajaxObj: ', ajaxObj);
54. return false;
55. });
56. 
    
57. /*Apply the tablesorter JQuery plugin to the summary table*/
58. campaign_summary.table.tablesorter({
59. theme: 'blue',
60. widthFixed: true,
61. sortLocaleCompare: true,
62. widgets: ['zebra'],
63. sortList: [ [0,1] ],
64. headers: {
65. '.pager' : {
66. sorter: false
67. },
68. '.no_sort' : {
69. sorter: false
70. }
71. }
72. });
73.  
74. /*Apply the pager to the summary table, also provides AJAX calls */
75. campaign_summary.table.tablesorterPager({
76. container: $("#campaignTable .pager"),
77. removeRows: false,
78. cssGoto: '.gotoPage',
79. ajaxUrl: VALIDATION_URL + '?operation=get_campaign_summary&page={page}&size={size}&{sortList:column}',
80. customAjaxUrl: function(table, url) {
81. $(table).trigger('changingUrl',url);
82. return url;
83. },
84. ajaxObject: {
85. dataType: 'json'
86. },
87. ajaxProcessing: function(data) {
88. // Code to handle data recieved from database  
89. if(!data){return;} //if nothing recieved exit
90. total = data.total;
91. if(total < 1){
92. campaign_summary.body.empty();
93. }
94. // console.log('Data: ', data);
95. // console.log('Data Row: ', data.rows);
96. rows = rows_to_array(data.rows);
97. headers = $.makeArray(data.headers);
98. headers.push(''); //end of array
99. return [total, rows, headers]; //Required return for pager to function
100. }
101. });
102.  
103.   /*converts the data for ticket table into an array*/
104. function rows_to_array(rows){
105. var ret = []
106. for(i=0;i<rows.length;i++){
107. ret.push(row_to_array(rows[i]));
108. }
109. return ret;
110. };
111.  
112. /*converts one row of ticket table data into an array*/
113. function row_to_array(row){
114. var ret = [];
115. ret.push(row['name']);
116. ret.push(row['discount_rate']);
117. ret.push(row['redeem_limit']);
118. ret.push(row['imported_files']);
119. ret.push(row['active_codes']);
120. ret.push(row['future_codes']);
121. ret.push(row['expired_codes']);
122. ret.push(row['redeemed_codes']);
123. ret.push(row['total_codes']);
124. ret.push('<a href="#" onclick="update_details(&quot;' + row['id'] + '&quot;,&quot;' + row['name'] + '&quot;)">View</a>');
125. return ret;
126. };
127. 
     
128. }
129. 
     
130.   function request (options, callback) {
131.     
132.     // if a request has been sent out cancel it
133.     if (xhr) {
134.     
135.       // IE 7 fix
136.       try {
137.         xhr.abort();
138.       }
139.       catch(e){}
140.     }
141.     
142.     // send another request, store the jqXHR object
143.     xhr = $.ajax({
144.       type: 'GET',
145.       url: VALIDATION_URL,
146.       data: options,
147.       success: function (data) {
148.         callback(data);
149.       },
150.       dataType: 'json',
151.       error: function () {
152.       }
153.     });
154.     // return xhr;
155.   }
156.  
157.  $(initialize)

Partial Ajax script showing get_campaign_summary call

1. ......
3. case 'get_campaign_summary':
4. log_message(log_var_dump($request));
5. $campaign_array = explode(',',$request->campaign_array); // creates an array from the comma delimited string
6. $response = get_campaign_summary($campaign_array,$request->filter,$request->column,$request->page,$request->size,false,false);
7. log_message(log_var_dump("RESPONSE: " . $response));
8. break;
9. ........
11. endswitch;
13. echo json_encode($response);
14. exit(0);
15. 
    

I know this is a lot to look at, and will probably be quite confusing. I will attempt to answer any questions. If need be, I can try attaching the full files (including the page HTML and query), but I'm trying to show only what I think is really needed.

As I said, I  have taken over someone else's code, and I myself am having difficulty with it. It seems over complicated, but this is what I have to work with.

In campaigns.js, I can see that the query has run and I have the correct information in "data"

I am just not sure how to get the  campaign_summary.table to reload with this new data.

Thanks in advance for any and all help.