Creating coherent and coordinated links between Results and Details pages

Hello,

I have just disocvered that webassist is automatically rewriting my queries, which is now why I believe (but possibly wrongly) that I have been unable to put together my pages and queries.

If I try to use variables to set up the following query with LIMITs in place and so I can control the paging:

<?php $starthighlight = 1;
$numberofhighlights = 4; ?>
<?php
$rsPresenterHighlights = new WA_MySQLi_RS("rsPresenterHighlights",$mysqli_navayogimarga,$numberofhighlights,$starthighlight);
$rsPresenterHighlights->setQuery("SELECT * FROM presenter_data WHERE ID >= 1 ORDER BY `Last`,`First` ASC ");
$rsPresenterHighlights->execute();
?>

then when I run the script, webassist eventually overwrites my original query to:

<?php
$rsPresenterHighlights = new WA_MySQLi_RS("rsPresenterHighlights",$mysqli_navayogimarga,0);
$rsPresenterHighlights->setQuery("SELECT * FROM presenter_data ");
$rsPresenterHighlights->execute();
?>

meaning it ignores my requests. And since the query is of course at the head, it never previously occurred to me to go back and check what was happening.

I have also found that QueryBuilder is failing. It either hangs; or else it tells me that it cannot recognize any of the table or columns, and that these will be deleted. I therefore used some third-party software to build the queries I wanted; which I am now finding webassist will not accept.

I am hopeful that some kind of workaround exists that will allow me to achieve the objectives I have in mind?

I still accept that I am somehow applying a flawed logic, and that that is why the queries are not "sticking", and not allowing me to use the variables I need.

Thank you for your kindness.
KAB