hi there, i got problems in sorting.

hmm.. let's say i have 10 records. then 1 page i will only display 5 records. tat means i will have 2 pages.

so when a user click a button on tat page, it will sort teh first page only without influencing the second page.

my problem is, i dono how to do tat. now when i click sort, it will sort the 10 records, then only display it. but wat i want is, display first, then only sort in the 5 record.

this is the query i have now...

Code:
$strQ = 'SELECT * FROM "vw_User1"';

$strQ .= ' WHERE ' . $strVar ;		
		
if ( !empty( $strField ) ) 
{
$strQ .= ' ORDER BY "' . $strField . '" ' . $strSort;		
}
		
$strQ .= ' LIMIT ' . $GLOBALS["intLimit"] . ' OFFSET ' . $page;
pls advise..