October 12th, 2003, 09:22 PM
display record first then only sort.
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...
$strQ = 'SELECT * FROM "vw_User1"';
$strQ .= ' WHERE ' . $strVar ;
if ( !empty( $strField ) )
$strQ .= ' ORDER BY "' . $strField . '" ' . $strSort;
$strQ .= ' LIMIT ' . $GLOBALS["intLimit"] . ' OFFSET ' . $page;