displaying all entries in database

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

displaying all entries in database

Post by Thunderstone »




Drop the "where Title\Meta\Body likep $query" clause from the <SQL>
statement; then every row will be selected. Also remove any other
references to $query.

You'll also have to set $indexcount yourself for the page counts to be
accurate, since there is no query. Before the <SQL> loop, count
the number of rows: <SQL "select count(Url) NumRows from html"></SQL>.
Then replace the "Word count: $query: $indexcount" line inside the loop with
<$indexcount = $NumRows>.

Or just let everything come out on one page by removing the "max=10"
from the <sql> statement and remove the <pagenum> call and any references
to $indexcount.

For further help with vortex and sql, please see the manuals:
http://www.thunderstone.com/vortexman/node3.html
http://www.thunderstone.com/texisman/texis.html


Post Reply