Multiple Column Sorting Not Working
I cannot get multiple columns to sort. I can get only one, but when I add multiple, the page continues to come up blank.
I cannot get multiple columns to sort. I can get only one, but when I add multiple, the page continues to come up blank.
a blank page means that a php error is occurring but error reporting is turned off.
to turn error reporting on, add the following code at line 1:
<?php
error_reporting(E_ALL);
ini_set('display_errors','on');
?>
once we know what the error is, we will be able to troubleshoot the cause.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'article_title' at line 1
the default sort setting needed to be updated to:
$WADA_Sort_1->DefaultSort = "ORDER BY article_title";
it is now showing an error about undefined variables:
Notice: Undefined variable: static_articles in D:\PLESK\VHOSTS\redsneakers.net\office-furniture\admin\article_list_test.php on line 217 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, null given in D:\PLESK\VHOSTS\redsneakers.net\office-furniture\admin\article_list_test.php on line 217
this code:
<?php } while ($row_static_articles = mysql_fetch_assoc($static_articles)); ?>
is referencing a recordset that does not exist.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.