On Sunday 04 July 2004 02:52 am, Gary Mack wrote:
> Hi there,
> I recently learned about LIMIT so that I can page
> through records on a web page I am creating.
> However, when coupled with ORDER BY, the sorting
> does not work anymore. Can someone look at my below
> query and point out what I am doing wrong? Thanks.
> This is my first time posting to this list, so I
> hope I have the right place. I want to sort by the
> client's last name and then by the staff person's
> last name.
> $qClients = "SELECT * FROM clients, staff WHERE
> clients.AssignedTo = staff.StaffID ORDER BY
> clients.LastName, staff.StaffLastName ASC LIMIT " .
> $limitStart . "," . $recordsPerPage;
Looks good to me.
Can you be more specific about what the problem is?