Hello,
can somebody help me to solve a problem whith database query.
I use "SQL query plugin" and "Bureaucracy Plugin" with "pagemod".
I have created a page with a form:
<form>
action pagemod sql-table database
textbox searchtext
submit
</form>
After entering the searchtext, pagemod modifies the page "sql-table" which lokks like:
<pagemod database output_after>
<sql>SELECT * FROM mydatabase WHERE col-1 LIKE @@searchtext@@ LIMIT 100</sql>
</pagemod>
The query works and a new table with query results is added to the page "sql-table".
My problem:
After every new query the resulting table is added to the result page.
But I need a new clean page with only the last result.
How can I achive this?
Uwe