Re: Sorting MYSQL results Paging and column heads

Edward Brookhouse wrote:

Hi All, I am working on a PHP page to display results from a MySQL db and I am having a problem getting my results to page properly. When the page loads, it looks fine, but hitting next/previous does not change the data?

<snip>

db_connect_ecelerity(DBUSER, DBUSERPW); $query1 = "select * FROM bouncelog ORDER BY insert_date DESC LIMIT $offset, $rowsPerPage";

Is it running this query or the next one?

            if(!$rs = mysql_query("SELECT * FROM bouncelog ORDER BY $col $dir LIMIT 500")) {
                echo "Cannot parse query";

There's only a limit here, no offset attached. -- Postgresql & php tutorials http://www.designmagick.com/