How can i get more then 50 results to display in excel using mysql?
===

I've searched and searched and i can't find my answer. i'm hoping someone can help. I have a code that searches a mysql database and displays X amount of results on a website. I searcher can then export the results into an excel spreadsheet. my problem is the results come back in the hundreds and the spreadsheet will only show me 50. there is a lot more to this code but something is telling me perhaps it's in here and to save putting over 400 lines of code in i'm showing this.




    $sql .= ",
                            IF (cycle_id = 4,
                                " . ((4 == $next_available_quarter) ?
                                    "'" . $next_available_quarter_month[4] . "-{$next_available_quarter_year}'" :
                                    "'" . $next_available_quarter_month[4] . "-" . ($next_available_quarter_year+1) . "'") . "
                                ,
                                IF (cycle_id = 3,
                                    " . ((3 == $next_available_quarter) ?
                                        "'" . $next_available_quarter_month[3] . "-{$next_available_quarter_year}'" :
                                        "'" . $next_available_quarter_month[3] . "-" . ($next_available_quarter_year+1) . "'") . "
                                    ,
                                    IF (cycle_id = 2,
                                        " . ((2 == $next_available_quarter) ?
                                            "'" . $next_available_quarter_month[2] . "-{$next_available_quarter_year}'" :
                                            "'" . $next_available_quarter_month[2] . "-" . ($next_available_quarter_year+1) . "'") . "
                                        ,
                                        " . ((1 == $next_available_quarter) ?
                                            "'" . $next_available_quarter_month[1] . "-{$next_available_quarter_year}'" :
                                            "'" . $next_available_quarter_month[1] . "-" . ($next_available_quarter_year+1) . "'") . "
                                        )
                                    )
                                )
                            )
                        )
                    )
                ) as next_run
        FROM
            tax_search_loans tsl
        LEFT JOIN
            tax_searches ts
        ON
            (tsl.tax_search_loan_id = ts.tax_search_loan_id)
        LEFT JOIN
            tax_search_results tsr
        ON
            (tsr.tax_search_id = ts.tax_search_id)
        LEFT JOIN
            states
        ON
            (tsl.state_id = states.state_id)
        LEFT JOIN
            tax_search_loan_officers tslo
        ON
            (tslo.tax_search_loan_officer_id = tsl.tax_search_loan_officer_id)
        WHERE
            tsl.active = 'Y' AND
            tslo.active = 'Y' AND
            tslo.customer_code IN ('" . implode("','", explode(',', $DB->cleanString($_GET['custcodes']))) . "') AND
            (ts.active IS NULL OR ts.active = 'Y') AND
            (tsr.active IS NULL OR tsr.active = 'Y')
			LIMIT 0, 50
        ";


