Trying to sort msyqli recordset with the GET parameter
I know that Data Assist doesn't work yet with mysqli, however, I tried to manually add this and have come up with the following :
$rsProds = new WA_MySQLi_RS("rsProds",$con,0);
$rsProds->setQuery("SELECT * FROM products ORDER BY ? ASC");
$rsProds->bindParam("s", "".((isset($_GET["sort"]))?$_GET["sort"]:"") ."", "ProductName"); //sortby
$rsProds->execute();
But this doesn't work.. neither for the default value of "ProductName", nor the GET parameter. Just curious what I can do?