MySQL infinity?

Hi,

Does anyone know if mysql has a way of representing infinity. I want to use it
as the default for some limit statements.

example :

//Limit defaults...
$start_offset = 0;
$total_items = 'infinity';

... may be overriden at some point here ....

$query = 'SELECT fields FROM table LIMIT ' . $start_offset ', ' . $total_items;

Right now, I just have $total_items set to a really large number, but that
doesn't seem overly cool. At the very least, is there a max result set size
imposed by php or mysql and would there be a way to get that?

Thanks,

Blaine




--
Blaine Garrett
Chief Web Applications Developer
JR Computer Associates INC
http://jrcorps.com
blaine-4hELYU93S8xBDgjK7y7TUQ@xxxxxxxxxxxxxxxx




---------------------------------------------------------------------
To unsubscribe, e-mail: talk-unsubscribe-4zcLI8jJc/rYtjvyW6yDsg@xxxxxxxxxxxxxxxx

Please read and follow the list guidelines:
  http://www.tcphp.org/mailing_list/guidelines

The tcphp.org mailing list is sponsored by pajunas interactive, inc.