in showresults i am doing (all caps are just for easy readability)
<loop skip=$ignore max=$SSc_hitsperpage $Url $UrlDisplay $Depth $Title $Description $Body $Size $Modified $Visited $id $Charset $rawrank $Docsize $urlseq $urlprofile>
<$next=($firsthitno+$loop)>
<result><!-- display the result record -->
<SQL NOVARS "UPDATE HTML SET VIEWS=(VIEWS+1) WHERE ID=$ID"></SQL>
</loop>
Obviously, the loop and next variables for the outer loop and inner sql statement are getting messed up somewhere so that when I display the 10 results, $next resets back to 1.
Kai did suggest use of local variables and so I tried using them but looks like I don't know the exact place I should be saving the loop and next variables.
Can you help me out here? I want to increment the Views field in html table for each result record I display.
<loop skip=$ignore max=$SSc_hitsperpage $Url $UrlDisplay $Depth $Title $Description $Body $Size $Modified $Visited $id $Charset $rawrank $Docsize $urlseq $urlprofile>
<$next=($firsthitno+$loop)>
<result><!-- display the result record -->
<SQL NOVARS "UPDATE HTML SET VIEWS=(VIEWS+1) WHERE ID=$ID"></SQL>
</loop>
Obviously, the loop and next variables for the outer loop and inner sql statement are getting messed up somewhere so that when I display the 10 results, $next resets back to 1.
Kai did suggest use of local variables and so I tried using them but looks like I don't know the exact place I should be saving the loop and next variables.
Can you help me out here? I want to increment the Views field in html table for each result record I display.