MySQL Limit function
mysql_data_seek ($recordsetName, 1);
where recordsetName is the name of the recordset.
Thanks jason I managed a work around by editing the code "$query_limit_Recordsetlivecustomers = sprintf("%s LIMIT %d, %d", $query_Recordsetlivecustomers, $startRow_Recordsetlivecustomers, $maxRows_Recordsetlivecustomers);to " "%s LIMIT 2, 100" and it worked fine thanks. I will use the mysql data seek in future though.
Thanks again