jQuery : Select All Checkbox


Yahoo! Mail and GMail both has a checkbox on top of their email list which will “checked” all chekboxes when clicked. Previously I use plain old javascript like those in this link, I just try to use jQuery to do this, its only 5 lines

$('#selectAll').click(function(event){
    $('input[type="checkbox"]').each(function(){
        this.checked = event.target.checked;
    });
});
Advertisements

MySQL – Select From Certain Record To The Last Record


To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:

SELECT * FROM tbl LIMIT 96, 18446744073709551615;

 

18446744073709551615 is 2^64-1 for those who were wondering. You may want to watch out because you won’t be able to store this value in an 32 bit integer. You have to make sure you store this as a string to ensure compatibility

18446744073709551615 is the maximum value of unsigned BIGINT

 

source:

http://stackoverflow.com/questions/255517/mysql-offset-infinite-rows